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

HOw can we load the normalised data ( Vertical data) to
(Horizontal data)with out using decode in the expression
transformation and the aggregator transformation. But,
what exactly I want is .. If we have million of records,it
is not possible using decode and search for that Particular
Id to pivot into Horizontal data... Can any one of guys
please help me in this regard.....

Question Posted / harish kakarlapudi

Answers were Sorted based on User's Feedback



HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in ..

Answer / harish kakarlapudi

Hi Srinivas,

It is opp. to Normalisation process, so, i think that it
cannot be done using Normaliser transformation. Can you
give me any idea , pls...

Is This Answer Correct ?    0 Yes 0 No

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in ..

Answer / friend

Use SQL Transformation for your process

Is This Answer Correct ?    0 Yes 1 No

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in ..

Answer / srinu

Hi,

Check with Normaliser Transformation
it will help you.


Any queries !! let me know
srinu.srinuvas@gmail.com

Is This Answer Correct ?    3 Yes 7 No

Post New Answer

More Informatica Interview Questions

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

How to create Target definition for flat files?

0 Answers   Informatica,

What is source qualifier?

6 Answers   SDS,

How can informatica be used for an organization?

0 Answers  

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

Define pmcmd command?

0 Answers  

Tell me about Propagate functions in informatica

0 Answers  

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

For more Informatica Interview Questions Click Here
Categories