Answer Posted / sai suresh
I think look up is a transformation it is mostly used for
slowly changed dimenctions(SCD). with the help of look up
T/R we can join to dimention tables. These tables may
Hetrogonies tables
Posni_sai@yahoo.com
sai suresh
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What differs when we choose the sorted input for aggregator transformation?
What is the benefit of partitioning a session?
Briefly explain the aggregator transformation?
What is aggregator transformation in informatica?
Explain the different dimensions.
Mention few advantages of router transformation over filter transformation.
What are the types of data warehouses?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
tell me about your project functionality
Parameter and variable differences
How to open an older version of an object in the workspace?
Where can we find the throughput option in informatica?
How to start a workflow using pmcmd command?
Slowly changing dimensions, types and where will you use them
