Answer Posted / sarvesh
by using the load manager
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the types of presistent cache in look up tr.
Differentiate between router and filter transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain sessions and how many types of sessions are there?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is the need for an etl tool?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain the features of connected and unconnected lookup.
What is the use of transformation?
What is informatica worklet?
What are the reusable transformations?
What are connected or unconnected transformations?
Design a mapping to load a target table with the following values from the above source?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.