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 / suresh

Use Sequence generator
In sequence generator set the properties
start value 1
end value 3
cycle yes
conn sequence generator to exp and test in router

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what transformation and how many are there in informatica?

478


How to do the error handling of if ur source is flatfiles?

1502


How can you increase the performance in joiner transformation?

698


What is transformation?

654


What are the various types of transformation?

638






What are the performance considerations when working with aggregator transformation?

672


What is dimensional table?

617


Define pmcmd command?

616


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

769


How many numbers of sessions can one group in batches?

614


Explain the difference between mapping parameter and mapping variable?

600


What does refresh system mean, and what are its distinctive choice?

564


What is an unconnected transformation?

659


What are the limitations of joiner transformation?

647


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

687