Answer Posted / uppala chary
The dimension which is not connected to any of the fact tble but key
exists in the fact table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How does the aggregator transformation handle null values?
Differentiate between Load Manager and DTM?
Different qualification between a related rotate toward the sky and isolates look upward?
How to join three sources using joiner? Explain though mapping flow.
What are the differences between oltp and olap?
Is there any target staging area in informatica not staging area
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the types of caches in lookup?
scenario where i can use only concurrent execution of workflow.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
State the limitations where we cannot use joiner in the mapping pipeline?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
can u any challenge your project?
What is dimensional table? Explain the different dimensions.
To import the flat file definition into the designer where should the flat file be placed?