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

I've a denormalized table
EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to
insert the record into target in the format that, there will
be 2 target rows for 1 source record. In target the row
needs to be inserted as:
ROW1: empno,ename,addr1,phone
ROW2: empno,ename,addr2,fax,email

And I'm not allowed to normalize transformation. How to achieve?

Question Posted / suman


I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert ..

Answer / rampriya

We can have two target instance of the same table. Load the
first row1 to 1st instance and row2 to 2nd instance.

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Informatica Interview Questions

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

"Change cache" in Informatica ?

2 Answers  

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

How do you convert single row from source into three rows into target?

0 Answers  




what is diff between grep and find

3 Answers   IBM, iFlex,

What is Session and Batches?

0 Answers   Informatica,

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories