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
- 9967 Views
- ITC Infotech, TCS, I also Faced
- E-Mail Answers
Answer Posted / susanta
Take a sequence generator with Start Value=1,Current
Value=1,End Value=3, Increment By=1 to assign a seqno to
each row. Do not forget to enable the cycle option.
after that take a Router with three groups of
seqno=1,seqno=2 and seqno=3.
Hope this will help u
| Is This Answer Correct ? | 28 Yes | 1 No |
Post New Answer View All Answers
how to create user defined function (udf) in informatica
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Explain lookup transformation is active in informatica
What is mapping debugger?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Is it possible to define a single node as a Gateway node as well as worker node?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What if the source is a flat-file?
What do think which one is the better joiner or look up?
Different circumstance which drives informatica server to expel records?
What are the static cache and dynamic cache in informatica?
what is the complex transformation you used in informatica
How do you take back up of repository?
