Interview Questions Answers in Informatica

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 # 19425

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 3412

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 4436

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 4699

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 6878

Answers / { ankita }

Question { HCL, 6878 }

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