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 an expression transformation in informatica?
Write the prerequisite tasks to achieve the session partition?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Tell me about MD5 functions in informatica
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?
Briefly explain the aggregator transformation?
What is status code in informatica?
How to load last n records of file into target table - informatica
How many dimensions are there in informatica?
differences between service based and product based?
What is informatica? Why do we need it?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
which one is better performance wise joiner or look up
can any one explain about dataflow in the informatica project for bank domain....thanks is advance