I have one source table and three target tables.
When the session runs for the first time involving the
mapping,i want that the loading should take place in 1st
Target table only.
The 2nd time the same session runs the loading should take
place in 2nd Target only only
and similarly when the session runs for the 3rd time loading
should take place in Third only.
And again when the session runs for the 4th time loading
should take place in 1st Target table.
- 4 Answers
- 11785 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / bhupal
Hi all,
Use sequence generator to generate the sequence.
properties should be
start value=1
end value=3
check the cycle option.
connect this nextvalue port to router and make there groups.
group_1----> nextvalue=1
group_2----> nextvalue=2
group_3----> nextvalue=3
connect first group to first target and second group to second target and then third to third.
flow will be like this
sequence generator
|
source---->source qualifier---->router--------Target 1
|-----------Target 2
|-----------Target 3
please let me know if you have any new questions.
mail id: bhupalreddy200@gmail.com
| Is This Answer Correct ? | 1 Yes | 20 No |
Post New Answer View All Answers
How to update or delete the rows in a target, which do not have key fields?
What is the meaning of decode in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is sq transformation?
Name the different lookup cache(s)?
What is meant by lookup transformation? Explain the types of lookup transformation?
How does a sorter cache works?
Plz can any one say me how to get the informatica certification materials and dumps
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the different types of repositories created using informatica?
What is a dimensional model?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain the features of connected and unconnected lookup.
What is a snowflake schema?
4 yrs etl devloper roles and responsibilities?any body give solutions
