Answer Posted / murali
in the schema, if any any dimension table has been shared
by more than one fact table, it is called as "confirmed
dimension"
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Have you worked with/created Parameter file
How to generate sequence numbers without using the sequence generator transformation?
What is a filter transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
tell me 5 session failure in real time how can you solve that in your project?
What is aggregate cache in aggregator transformation?
Why update strategy and union transformations are active? Explain with examples.
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?
How to join three sources using joiner?
Different qualification between a related rotate toward the sky and isolates look upward?
What is an aggregator transformation?
What are the new features of informatica 9.x in developer level?
Why sorter is an active transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a transaction control transformation?