Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Scenario:- 




Below is the requirement.




Source:- 
NAME          ID                    Requirement 
RAVI            1                      (no need to repeat as it ID is 1)
KUMAR        3                     (repeat 3 times as it ID is 3)
John             4                     (repeat 4 times as it ID is 4)




Required Out Put:-




Name                   ID
RAVI                     1                   
KUMAR                3     
KUMAR                3
KUMAR                3 
John                     4
John                     4
John                     4
John                     4

Scenario 2:-




Source Data 




ID              NAME
1,2            NETEZZA,ORACLE
3,4,5         SQL Server, DB2, Teradata




Required Output:- 




ID                   NAME
1                  NETEZZA
1                  ORACLE
3                  SQL Server
3                  DB2
3                  Teradata

Question Posted / krish


Scenario:-  Below is the requirement. Source:-  NAME     &nbs..

Answer / krish

http://netezzamigration.blogspot.com/2014/10/implementing-java-transformation-with.html

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

In informatica workflow manager, how many repositories can be created?

0 Answers  

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

How many cubes create from a single model?

1 Answers  

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

What is union transformation?

0 Answers  

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories