ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
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 Submitted By :: Harish Kakarlapudi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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.....
Answer
# 1		 
Hi,

Check with Normaliser Transformation
it will help you.


Any queries !! let me know
srinu.srinuvas@gmail.com
 
Is This Answer Correct ?    0 Yes 2 No
Srinu
 
  Re: 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.....
Answer
# 2		 
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
Harish Kakarlapudi
 
 
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
what is galaxy repository?  1
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?  4
what is the flow?  1
What is data merging,data cleansing,sampling?  2
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why? iFlex5
how do u tune queries?  1
What is the Difference between DSS & OLTP?  3
What is factless fact schema?  1
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-) ECI-Telecom2
task is running successfully but data is not loded why?  2
what is polling?  1
What is checksum termnology in informatica? Where do you use it ? Deloitte2
What is the difference between Normal load and Bulk load?  2
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?  2
Define maping and sessions?  3
Without source how to insert record to target?  4
What is a taget load order? IBM2
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani Wipro1
How to view and Generate Metadata Reports?  1
What are the different options used to configure the sequential batches? Wipro1
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com