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
- 14911 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 is a filter transformation?
How big was your fact table
what are the Methods For Creating Reusable Transformations?
Define update strategy?
What could be the possible resons of locks by user?
What are mapplets? How is it different from a Reusable Transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
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?
Difference between Data and Index Caches?
What is a transaction control transformation?
How to load the data from people soft hrm to people soft erm using informatica?
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.
Informatica settings are available in which file?
difference between informatica 8.1.1 and 8.6
