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
Explain sql transformation in script mode examples in informatica
waht type of interface is used for testing the data in informatica
Can we create two repositories on same database instance in oracle?
What are the types of caches in lookup?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to create or import flat file definition in to the warehouse designer?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Differentiate between router and filter transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain pushdown optimization and types in informatica
Explain target update override in informatica
what is SDLC way of code development?
differences between service based and product based?
Describe an informatica powercenter?
What is a rank transform?