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 / anu
take sequence generator connect neval port to router
in router create 3 groups
in 1st group (nextval<=100) or (nextval>300 and nextval<=400)
or (nextval>700 and nextval<=800)........trg1
in 2nd group (nextval>100 and nextval<=200) or (nextval>400
and nextval<=500) or (nextval>800 and nextval<=700)......trg2
in 3rd group (nextval>200 and nextval<=300) or (nextval>500
and nextval<=600) or (nextval>900 and nextval<=1000)......trg3
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How can you increase the performance in joiner transformation?
explain one complex mapping with logic? sales project?
What is the function of union transformation?
What are connected or unconnected transformations?
How many ways are there to create ports?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What does “tail –f” command do and what is its use as an Informatica admin.
Have you worked with/created Parameter file
Write the different tools in the workflow manager?
What are the types of caches in lookup? Explain them.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Describe the impact of several join conditions and join order in a joiner transformation?
Explain pushdown optimization and types in informatica
my source is junk data how will u remove that junk data by using unix please any one replay me
What is a sorter transformation?