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 Posted / 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 View All Answers
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is workflow? What are the components of the workflow manager?
Explain load alternative records / rows into multiple targets - informatica
What is a stored procedure transformation?
explain about unit testing? in real time?
In informatics server which files are created during the session rums?
permutations of mapplet
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the differences between joiner transformation and source qualifier transformation?
Explain how many types of dimensions are available in informatica?
How are indexes created after completing the load process?
what is the size of u r source(like file or table)?
Explian the Process of deployment groups in informatica
What is the Process to creating lookup transformation in informatica
Explain lookup transformation source types in informatica