Interested to Buy Any Domain ? << Click Here >> for more details...
i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2. what is the procedure and whar t/r's are involved
and what is the mapping flow
- 4 Answers
- 11988 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / anand kumar
We can do this in the following.
Take the sequence generator t/r
set the properties like
Start value 1
End value 2
and also Enable cycle option
connect the nextval port to the router T/r
port "SGTNO"(created by you) and also connect the ports
from source qualifier to the router t/r
Now given the first condition like
SGTNO=1 then go to first target
otherwise go to second target(here no need to mention the
second condition).
If I went wrong, please let me know
Thanks
Anand Kumar
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Define sessions in informatica etl?
What's the layout of parameter file (what does a parameter file contain?)?
what is Active lock explain
Can informatica load heterogeneous targets from heterogeneous sources?
Do you find any difficulty while working with flat files as source and target?
How can we remove the duplicates from flat file source?
What is flashback table ? Advance thanks
Differences between connected and unconnected lookup?
wat are deployement groups in informatica, how it will be used for developers
Can we create multiple integration service on single repository?
Explain the difference between mapping parameter and mapping variable?
explain about unit testing? in real time?
what is size of u r database?
What is the difference between writing a joiner query in ANSI style and THETA style?
How to start a workflow using pmcmd command?
