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
- 1 Answers
- 3016 Views
- I also Faced
- E-Mail Answers
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 |
Explain in detail about scd type 1 through mapping.
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
What is resilience time?
How many repositories can we create in Informatica?
how to we create datamart?
How to improve the performance of a session using sorter transformation?
How will u pas the data with out debugger?
Can you copy the session to a different folder or repository?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
what is left outer join?
Teradata 
