Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7084 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Take one variable $$var
in exp trans take one variable port and assign set variable($$var,$$var+1)
then take one router transformation with three group
mod($$var,3)=1 to one tgt
mod($$var,3)=2 to next tgt
mod($$var,3)=0 to another tgt
SD-SQ-EXP-ROUTER-TD1 TD2 TD3
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sg
SQ-Exp-Rou-Tg1 TG2 Tg3
Exp transformation: for generating sequence number ( u can use sequence generator setting max value to 3)
o_count = iff(o_count=0 or o_count=4,1,o_count+1)
Router group condition,
O_cout=1, TG1
O_cout=2, TG2
O_cout=3, TG3
| Is This Answer Correct ? | 0 Yes | 0 No |
Take a mapping variable of count type $$INCR=1
After SQ take expression and add a variable port
v_INCR_VARIABLE= IIF($$INCR=3,SETVARIABLE($$INCR,0)+1)
Take router and add three groups
Group1-> $$INCR=1
Group2-> $$INCR=2
Group3-> $$INCR=3
Add groups to respective targets.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Where is metadata stored?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
Enlist the advantages of informatica.
Describe the impact of several join conditions and join order in a joiner transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
HOW DO YOU CONNECT TO REMOTE SERVER ?
which transformation uses cache?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
How the facts will be loaded? explain
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
Can you copy the session to a different folder or repository?
Teradata 
