Answer Posted / srinivas
suppose i have 3 pipelines in a single mapping designer
emp source--->sq--->tar1
dept source--->sq--->tar2
bonus source--->sq--->tar3
my requirement is to load first in tar2 then tar1 and then finally tar3
for this type of loading to control the extraction of data from source by source qualifier we use target load plan
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
What are the issues you have faced in your project? How did you overcome those issues?
Explain about cumulative Sum or moving sum?
list out all the transformations which use cache?
Explain the types of lookup transformation?
What are the differences between a connected lookup and unconnected lookup?
Is it possible to use a client with different version than that of its Informatica server?
define galaxy repository in informatica
What is target load order?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the difference between writing a joiner query in ANSI style and THETA style?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
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 aggregate cache in aggregator transformation?
How do you load unique records into one target table and duplicate records into a different target table?
