Interested to Buy Any Domain ? << Click Here >> for more details...
I have a scenario like - how can i load 1st record to
Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to
repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
- 3 Answers
- 9826 Views
- ITC Infotech, TCS, I also Faced
- E-Mail Answers
Answer Posted / avatar dss42b88
for this we use sequence generator t/r,
ex take source emp
targets -emp1,emp2,emp3.
mapping structure
sq->(seq)->exp->rtr->emp1(condition rowid=1)
->emp2(condition rowid=2)
->emp3(condition rowid=3)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like
start value=1
increment by=1
last value=3
currval=1
cycle check it save it.
execute mapping.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Define Pmrep command?
How to handle decimal places while importing a flatfile into informatica?
How can we create index after completion of load process?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain the mapping variable usage example in informatica
What is depict expression change?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Performance tuning in UNIX for informatica mappings?
What does command task mean?
When do you use sql override in a lookup transformation?
How to implement security measures using repository manager?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the differences between a connected lookup and unconnected lookup?
4 yrs etl devloper roles and responsibilities?any body give solutions
Where are the source flat files kept before running the session?
