I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?
Answer Posted / teja_dwh
By using sequence generator properties we can do this.
setting the properties like below
start value:1
end value:3
cycle:yes
reset:yes
increment by:1
we can achieve the result by this way.
cheers
teja
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is the use of code page?
What is fact table? Explain the different kinds of facts.
Can we create multiple integration service on single repository?
wat are deployement groups in informatica, how it will be used for developers
Write the unconnected lookup syntax?
What is persistent lookup cache?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is the Rank index port in Rank transformation?
How to create or import flat file definition in to the warehouse designer?
What are the different options available for update strategy?
What is lookup change?
What is a repository? And how to add it in an informatica client?
Why sorter is an active transformation?
How can repository reports be accessed without sql or other transformations?
How to load data in informatica ?