Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


List the transformation used for the following:

(1) Heterogeneous Sources

(2) Homogeneous Sources

(3) Find the 5 highest paid employees within a dept.

(4) Create a Summary table

(5) Generate surrogate keys



List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sour..

Answer / nagapuri

1)Joiner Transformation
2)Source Qualifier and Joiner transformation
3)Rank Transformation.
4)Aggregator Transformation
5)Sequence Generator Transformation

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Informatica Interview Questions

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  


Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,


How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,


I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  


A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,


In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


is it possible to index the data in cache of lkp transformation ?

0 Answers  


Categories