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

what is parallel querying and what r hints.

1 Answers  

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

How can a transformation be made reusable?

0 Answers   Informatica,

What is the need of etl tools?

0 Answers  

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

Write the different tools in the workflow manager?

0 Answers  

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories