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
- 15020 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 types of data warehouses?
what is the hint? how to use it to reduce the query processing in program?
How many transformations can be used in mapplets.
When do you use sql override in a lookup transformation?
Explain Dataware house architecture .how data flow from intial to end?
What is a joiner transformation and why it is an active one?
What is status code in informatica?
What is dimensional table?
Performance tuning in UNIX for informatica mappings?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
how tokens will generate?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What does refresh system mean, and what are its distinctive choice?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the new features of informatica 9.x in developer level?
