Hi experts ,I have a Source of 1000 records.I have to load
100 records in first target,101 to 200 records in 2nd
target, 201 to 300 records in 3rd target and again 301 to
400 in first target like that as cyclick process. How can i
acheive this.
Answer Posted / anu
sq->(seq)->exp->rtr->emp1(condition rowid <=100)
->emp2(condition rowid >100 and rowid<=200)
->emp3(condition rowid >200 and rowid<=300)
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=300
currval=1
cycle check it save it.
Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
Differentiate between joiner and lookup transformation?
draw informatica architecture 8.6 ?
What are the limitations of joiner transformation?
lookup transformation with screenshots
Explain why we use partitioning the session in informatica?
Mention a few design and development best practices for informatica?
How to start a workflow using pmcmd command?
What is source qualifier transformation in informatica?
How do you change a non-reusable transformation to reusable transformation?
Can you generate sequence numbers without using the sequence generator transformation?
Can we create multiple integration service on single repository?
What are the transformations that are not supported in mapplet?
Whats there in global repository
Tell me about Propagate functions in informatica
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?