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

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

How to generate the HTML output using Informatica.

3 Answers   Wipro,

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,




Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

Do you find any difficulty while working with flat files as source and target?

0 Answers  

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

How to recover sessions in concurrent batches?

1 Answers  

Diffrence between static and dynamic cache

2 Answers   HCL,

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

For more Informatica Interview Questions Click Here
Categories