ankita


{ City } bangalore
< Country > india
* Profession * informatica developer
User No # 105411
Total Questions Posted # 4
Total Answers Posted # 1

Total Answers Posted for My Questions # 8
Total Views for My Questions # 15693

Users Marked my Answers as Correct # 6
Users Marked my Answers as Wrong # 0
Questions / { ankita }
Questions Answers Category Views Company eMail

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

HCL,

1 Informatica 2621

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

CTS,

2 Informatica 3617

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

HCL,

1 Informatica 3951

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

HCL,

4 Informatica 5504



Answers / { ankita }

Question { HCL, 5504 }

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


Answer

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