Hi please try to reply with answer. my mail id is
raghu.1028@gmail.com.
if the source is having millions of records, but having
theree target tables. As per user the first record need to
insert into first target and second record in to a second
target and third into third target, similarly the process
needs to repeat?
Answer Posted / balaganesh
Using Sequence Generator and router we can achive this
problem.
In Seq Gen:
1) Set current value is 1 and end value is 3. Also, enable
the recycle option.
Now using router you can separate the records into target.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
where is the cache (lookup, index) created and how can you see it.
What is abap? What are idocs?
Two default user groups created in the repository are____and_____.
what are the types in error loging?
how do use session mapping parameters ?(in which transformation)
What is staging area referring to?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Is hadoop a etl tool?
how do u identify the changed records in operational data?
What are the different Lookup methods used in Informatica?
What are the differences between sql override and update override?
what is the use of server manager?
What are various etl tools in the market?
what is pmrep command?
how do u set partition points in the mapping?