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
What is the status code in stored procedure transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain the different lookup methods used in informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the function of union transformation?
What is aggregate cache in aggregator transformation?
What's the layout of parameter file (what does a parameter file contain?)?
Write the prerequisite tasks to achieve the session partition?
Why update strategy and union transformations are active? Explain with examples.
How many ways a relational source definition can be updated and what are they?
Explain the types of lookup transformation?
Differentiate between source qualifier and filter transformation?
Briefly define reusable transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is joiner change?