ename,deptcount
vamshi,3
kumar,5
krish,8
in o/p i want vamshi record 3 times kumar record 5 times
like wise
what is the logic.?
give the entire logic plz



ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 time..

Answer / chandra

ITs simple by using normalizerTr

Is This Answer Correct ?    4 Yes 6 No

Post New Answer

More Informatica Interview Questions

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,


Can we create out put ports in source qualifier t/r?

5 Answers   TCS,


How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,


in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,


need for registering a repository server

1 Answers  






How do you implement configuration management in Informatica?

1 Answers  


There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,


difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,


What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  


If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers   Hexaware,


Categories