i have a source table and 3 target table.
when session runs first time-1st tgt
second time-2nd tgt
third time-3rd tgt
fourth time-again 1st target. so no
- 4 Answers
- 5535 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ganesh kamble
We can clearly understand that we need a Router transformation to route or filter source data to the three target tables. Now the question is what will be the filter conditions.
First of all we need an Expression Transformation where we have all the source table columns and along with that we have another i/o port say seq_num, which gets sequence numbers for each source row from the port NEXTVAL of a Sequence Generator start value 0 and increment by 1.
Now the filter condition for the three router groups will be:
MOD(SEQ_NUM,3)=1 connected to 1st target table MOD(SEQ_NUM,3)=2 connected to 2nd target table MOD(SEQ_NUM,3)=0 connected to 3rd target table
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the basic requirements to join two sources in a source qualifier transformation using default join?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What you know about transaction control transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
While migrating the data from one environment to another environment how would you manage the connections?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is deployment group?
Which is the t/r that builts only single cache memory?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
State the differences between sql override and lookup override?
Explain why we use partitioning the session in informatica?
is it possible to index the data in cache of lkp transformation ?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is informatica etl tool?
