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
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 |
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
what is the necessity to use update strategy?(except for updates)
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?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
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?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
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
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
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?
write a query to retrieve the latest records from the table sorted by version(scd)
is it possible to index the data in cache of lkp transformation ?