Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is the use of incremental aggregation?

2 Answers  

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

What is event and what are the tasks related to it?

0 Answers  

What is joiner transformation in informatica?

0 Answers  

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

what is casual dimension?

6 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories