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 |
what is the diff b/w union and joiner and lookup?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
why we need informatica
How many cubes create from a single model?
What is the cumulative sum and moving sum?
How can you differentiate between powercenter and power map?
How u use pdf file in informatica source?
what is inline view?
HOW DO YOU CONNECT TO REMOTE SERVER ?
According to his methodology what all you need before you build a datawarehouse
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?