what is target load plan
Answers were Sorted based on User's Feedback
Answer / ahalya inturi
target load plan defines order in which data extracted from
source qualifier transformation
Is This Answer Correct ? | 5 Yes | 2 No |
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 |
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..!
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
plz plz plz send client names and project names in informatica?
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
How to use procedural logic inside infromatica?
What is dimensional table? Explain the different dimensions.
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?
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
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
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 ?
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?
How identifying bottlenecks in various components of informatica and resolving them?