Скачать или смотреть Informatica Scenario 14/22

Top 10 salaries without rank


Informatica scenario list
----------------------------------
1)How to Separate duplicate values and distinct values from source by using aggregator transformation

   • How to Separate duplicate values and disti...  


2) How To Load Top 5 Records based on SAL without Using RANK transformation in Informatica

   • How To Load Top 5 Records based on SAL wit...  

3) How to load every 4th record into target table in Informatica

   • How to load every 4th record into target t...  

4)How to load data based on even and odd record numbers in Informatica

   • How to load data based on even and odd rec...  

5)Salary incrementing based on department by using router with expression

   • Informatica Scenario 1/22  

6) How to generate sequence number without using sequence generator transformation in informatica

   • Informatica Scenario 2/22  

7)Top 5 highly paid employees without using rank,sequence generator transformation in informatica

   • Informatica Scenario 3/22  

8)removing $ symbol from currency in informatica

   • Removing $ symbol from currency 4/22  

9)Creating email from first name,last name,organization name in informatica

   • Informatica Scenario 5/22  

10)Creating firstname,lastname,organigation name from email

   • Informatica Scenario 7/22  

11)How to convert dollar to rupee in informatica

   • Informatica Scenario 8/22  

12)How to find cumulative salary in informatica

   • Informatica Scenario 9/22  

13) How to load first record into one table second record into one table remaining will into another table

   • Informatica Scenario 10/22  

14) How to replace one character by another character by using replcachr function

   • Informatica Scenario 11/22  

15) How to load current salary for next employee

   • Informatica Scenario 13/22  

16) First salary as null and first row salary to second row in informatica

   • Informatica Scenario 13/22  

17) Top 10 salaries without rank

   • Informatica Scenario 14/22  

18) How to load numbers into one column alphabets into one column from single column

   • Informatica Scenario 15/22  

19) How to generate sequence number for two target tables by using only one sequence generator

   • How to genarate sequence number for two ta...  

20) Mapping to load all records except last 5 records

   • Informatica Scenario 17/22