following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?
Answer Posted / triveni
startvalue=1
endvalue=3
cycle=yes seequencegenerator
\
source->sq->expression->router->target1
->target2
expression->copy nextval port to expression
router->mod(seq,3)=1
mod(seq,3)=2
mod(seq,3)=0
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are data-driven sessions?
What differs when we choose the sorted input for aggregator transformation?
How many ways are there to do 'remove duplicate records in informatica'?
Write the advantages of partitioning a session?
How can we remove the duplicates from flat file source?
What is informatica powercenter repository?
What is the status code in stored procedure transformation?
How to extract the informatica rejected data?
Informatica Checkpoints
How we can use union transformation?
Differentiate between a database and data warehouse?
What are the new features of informatica 9.x in developer level?
How might one distinguish in the case of mapping is right or not without associating session?
What is union transformation?
What do you mean by channel change?