Interested to Buy Any Domain ? << Click Here >> for more details...
Create a mapping which contains 2 target tables. When the
session runs for the first time it shud load Target table 1
and when it runs for second time it shud load Target
table 2.
- 7 Answers
- 15250 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / perumal
Source -> sq -> sequence Generator -> exp trans -> router
trans -> tgt1/tgt2
create variable nxt_val with next value return from seq gen
and in router give rule as mod(nxt_val,2)<>0 to load tgt1
(since first run value will be 1) and mod(nxt_val,2)=0 to
load tgt2.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the differences between joiner transformation and source qualifier transformation?
Mention some types of transformation?
What are the different types of repositories created using informatica?
What are some examples of informatica etl programs?
Differences between version 7.x and 8.x.
How to create a non-reusable instance of reusable transformations?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Enlist the tasks for which source qualifier transformation is used.
Explain lookup transformation is active in informatica
What is meant by lookup transformation? Explain the types of lookup transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to load the data from people soft hrm to people soft erm using informatica?
How can you generate reports in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the sql query overwrite in source qualifier in informatica
