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
- 12321 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
How to delete duplicate row using informatica?
Explain sql transformation in script mode examples in informatica
Reusable transformation and shortcut differences
What is the difference between a repository server and a powerhouse?
What does role playing dimension mean?
Parameter and variable differences
Explain lookup transformation is active in informatica
What are the modules in Power Center
What is meant by incremental aggregation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Design time, run time. If you don't create parameter what will happen
Differentiate between router and filter transformation?
what is INFORMATICA TESTING process
What is a code page?
