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

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

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 confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

How can we use batches?

0 Answers  

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

Explain Dataware house architecture .how data flow from intial to end?

0 Answers   Keane India Ltd,

.prm wirh repalce .txt is possible?

2 Answers  

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories