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

When do you use sql override in a lookup transformation?

0 Answers  

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,

how i will stop my workflow after 10 errors

2 Answers   HP,

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  

What is rank transformation in informatica

0 Answers   Informatica,

In which circumstances that informatica server creates Reject files?

2 Answers  

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

Explain lookup transformation in informatica

0 Answers   Informatica,

Define pmcmd command?

0 Answers  

how many types of dimensions are available in informatica?

0 Answers  

How to load relational source into file target?

3 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories