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
- 14673 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
In development project what is the process to follow for an etl developer from day1
lookup transformation with screenshots
What is a transaction control transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
In informatics server which files are created during the session rums?
what is Active lock explain
Where are the source flat files kept before running the session?
What is difference between a gateway node and worker node?
Can we create a Integration service without a Repository service and vice versa?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is a node in Informatica?
What are active transformations.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is lookup change?
