Hi experts ,I have a Source of 1000 records.I have to load
100 records in first target,101 to 200 records in 2nd
target, 201 to 300 records in 3rd target and again 301 to
400 in first target like that as cyclick process. How can i
acheive this.
Answer Posted / ramana sreepathi
Take sequence generator connect nextval port to router
in router create 2 groups
in 1st group (TRUNC(nextval, -2) mod 200 = 0) or (TRUNC
((nextval – 1), -2) mod 200 = 0) ..... trg2
in 2nd group (TRUNC(nextval, -3) mod 300 = 0) or (TRUNC
((nextval – 1), -3) mod 200 = 0) ... trg3
in default group
trg3
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is data movement mode in Informatica and difference between them?
Sequence generator, when you move from develoment to production how will you reset
Explain how to import oracle sequence into informatica?
What is sorter transformation?
What is deployment group?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is meant by a domain?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
what is the complex transformation you used in informatica
What is the format of informatica objects in a repository?
What is union transformation in informatica?
Explain sql transformation in script mode examples in informatica
How can we remove the duplicates from flat file source?