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
- 6918 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 |
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
How does the session recovery work.
Briefly describe lookup transformation?
can we use mapplet as starting n ending object in mapping
How to Join Tables my Source is having 15 table target is one?
How can i set break points in debugging mode ? can explain steps please?
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
What is the procedure to load the fact table.Give in detail?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
Teradata 
