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

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,


i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,


plz plz plz send client names and project names in informatica?

1 Answers  


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  


How to use procedural logic inside infromatica?

0 Answers  






What is dimensional table? Explain the different dimensions.

0 Answers  


The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,


wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,


When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

0 Answers   IBM,


How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  


Categories