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 / gyana
source--->sq--->attached a sequence generator with settings
current value=1
start value=1
end value=3
incrimented by=1
cycle=yes
------->router(3groups)--->3 targets
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you load only null records into target?
What is a passive transformation?
What are ETL Tools?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the types of presistent cache in look up tr.
What is domain and gateway node?
Which files are created during the session rums by informatics server?
server hot-ws270 is connect to Repository B. What does it mean?
What are pre and post-session shell commands?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is a connected transformation?
What are the main features of Oracle 8i with context to datawarehouse?
What is the surrogate key?
Whats there in global repository