what is target load plan

Answers were Sorted based on User's Feedback



what is target load plan..

Answer / ahalya inturi

target load plan defines order in which data extracted from
source qualifier transformation

Is This Answer Correct ?    5 Yes 2 No

what is target load plan..

Answer / 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

More Informatica Interview Questions

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,


Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  


How to join three sources using joiner?

0 Answers  


Can you generate reports in Informatcia?

1 Answers  


What is DR strategy for Informatica project?

0 Answers  






What is a data modeling?

2 Answers  


What is staging area?

11 Answers  


Why use shortcuts(Instead of making copies).

1 Answers  


What is power play plug in?

2 Answers  


what is the monster dimension plz give me one example

2 Answers   EDS,


On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records

1 Answers  


What are the prerequisite tasks to achieve the session partition?

0 Answers  


Categories