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
Explain the shared cache and re-cache?
What are mapplets?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Please let me know how to make encryption and decryption with example?
What is meant by pre and post session shell command?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How does a sorter cache works?
Explain the mapping variable usage example in informatica
Is stop and abort are same in informatica?
What are the main features of Oracle 8i with context to datawarehouse?
Why do we need informatica?
Explain pmcmd command usage in informatica
Target increases every day even though no new record was inserted
Under which circumstances, informatica server creates reject files?
What is a node in Informatica?