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 can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

What is sq transformation?

0 Answers  

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

What are the advantages of informatica?

0 Answers  

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

Which is the t/r that builts only single cache memory?

0 Answers  

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

What are the reusable transforamtions?

2 Answers  

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