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?
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
Separate from a database, an information bazaar, and an information stockroom?
write a query to retrieve the latest records from the table sorted by version(scd)
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is InformaticaPowerCenter?
How do you handle two sessions in Informatica
What do you mean incremental aggregation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is a sorter transformation?
What is the difference between informatica 7.0 and 8.0?
How to create the source and target database connections in server manager?
What is depict expression change?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
explain about unit testing? in real time?
What are the new features of Power Center 5.0?
In which transformation you cannot drag ports into it?