Scribd
Upload
4K views2 pages

Informatica Complex Realtime Scenarios

The document lists 20 real time scenarios for data loading and transformation in Informatica. The scenarios include how to separate duplicate and distinct values, load top 5 records without rank, load every 4th record, load data based on even and odd records, increment salary by department, generate sequence numbers without sequence generator, load top 5 salaries without rank, remove symbols from currency, create email from names, convert currency, find cumulative salary, load records to different tables, replace characters, load current salary for next employee, set first salary to null and copy to next row, load top 10 salaries without rank, load numbers and alphabets to separate columns from one column, generate sequence for two tables from one generator, and load all records except

Uploaded by

Mahesh G Raju
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4K views2 pages

Informatica Complex Realtime Scenarios

The document lists 20 real time scenarios for data loading and transformation in Informatica. The scenarios include how to separate duplicate and distinct values, load top 5 records without rank, load every 4th record, load data based on even and odd records, increment salary by department, generate sequence numbers without sequence generator, load top 5 salaries without rank, remove symbols from currency, create email from names, convert currency, find cumulative salary, load records to different tables, replace characters, load current salary for next employee, set first salary to null and copy to next row, load top 10 salaries without rank, load numbers and alphabets to separate columns from one column, generate sequence for two tables from one generator, and load all records except

Uploaded by

Mahesh G Raju
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Informatica Real time Scenarios List

--------------------------------------------------------------1)How to Separate duplicate values and distinct values from source by using aggr
egator transformation
[Link]
2)
How To Load Top 5 Records based on SAL without Using RANK transformation in Info
rmatica
[Link]
3)
How to load every 4th record into target table in Informatica
[Link]
4)How to load data based on even and odd record numbers in Informatica
[Link]
5)Salary incrementing based on department by using router with expression
[Link]
6)How to generate sequence number without using sequence generator transformatio
n in informatica
[Link]
7)Top 5 highly paid employees without using rank,sequence generator transformati
on in informatica
[Link]
8)removing $ symbol from currency in informatica
[Link]
9)Creating email from first name,last name,orgnization name in informatica
[Link]
10)Creating firstname,lastname,organigation name from email
[Link]
11)How to convert dollar to rupee in informatica
[Link]
12)How to find cumulative salary in informatica
[Link]
13)How to load first record into one table second record into one table remainin
g will into another table
[Link]
14)How to replace one charecter by another charecter by using replcachr function

[Link]
15)How to load current sal for next extemployee
[Link]
16)First salary as null and first row salary to second row in informatica
[Link]
17)Top 10 salaries without rank
[Link]
18)How to load numbers into one column alphabets into one column from single col
umn
[Link]
19)How to genarate sequence number for two target tables by using only one seque
nce genarator
[Link]
20)Mapping to load all records except last 5 records
[Link]

You might also like