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
- 15003 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 uses of etl tools?
design of staging area?
What is dynamic cache?
While migrating the data from one environment to another environment how would you manage the connections?
How to extract sap data using informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is size of u r database?
Sequence generator, when you move from develoment to production how will you reset
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the function of aggregator transformation?
What does reusable transformation mean?
which one is better performance wise joiner or look up
How to improve the performance of a session using sorter transformation?
