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
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 does a sorter cache works?
How to create the source and target database connections in server manager?
What are the new features of informatica 9.x at the developer level?
Define joiner transformation?
waht type of interface is used for testing the data in informatica
What is meant by query override?
What is the difference between router and filter?
Mention few advantages of router transformation over filter transformation.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Can we change Dynamic to Static or Persistent cache? If so what happens?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How might you approve all mappings in the archive all the while?
Can you use flat files in Mapplets.