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
How do you convert single row from source into three rows into target?
scenario where i can use only concurrent execution of workflow.
In development project what is the process to follow for an etl developer from day1
What is a snowflake schema?
Explain the aggregator transformation?
COM components can be used in Informatica
How to generate sequence numbers using expression transformation?
Differentiate between Load Manager and DTM?
What is data caches/ index caches?
How you can differentiate between connected lookup and unconnected lookup?
What is a passive transformation?
Can we create two repositories on same database instance in oracle?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain the difference between a data warehouse and a data mart?
What is target load order?