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
- 13768 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
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are batches?
What is the difference between source qualifier transformations source filter to filter transformation?
How to differentiate between the active and passive transformations?
What are ETL Tools?
What you know about transaction control transformation?
What is the difference between a connected look up and unconnected lookup?
Mention some types of transformation?
How union transformation is used?
Under what condition selecting sorted input in aggregator may fail the session?
What is informatica worklet?
What is status code in informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Explain pushdown optimization and types in informatica
What is target designer and target load order?
