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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  ETL
 
 


 

 
 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 
Which type or t/s is used to convert rows into column & 
column into rows
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Which type or t/s is used to convert rows into column & column into rows
Answer
# 1		 
You can achieve through Normalizer t/f
 
Is This Answer Correct ?    1 Yes 1 No
Krishna
 
  Re: Which type or t/s is used to convert rows into column & column into rows
Answer
# 2		 
by using normaliser ransformation only you can convert the 
rows to columns and vice versa
 
Is This Answer Correct ?    0 Yes 1 No
Vijay
 
 
 
  Re: Which type or t/s is used to convert rows into column & column into rows
Answer
# 3		 
By using normalizer transformation we can use the conditions
only applied for row by columns..

by using the normalizer output we can use the function (first) 
and then applied for conditions ..and then output will be
seen in  column by rows....
 
Is This Answer Correct ?    0 Yes 0 No
Murugan
 
  Re: Which type or t/s is used to convert rows into column & column into rows
Answer
# 4		 
Row To columns
--------------

Use Normalizer Transformation


Column To Rows
--------------

SOURCE
------
ENO   COL_HDR    COL_VAL
------------------------
1     ENAME      PRAKASH
1     ESAL       35000
2     ENAME      SREE
2     ESAL       25000  

OUTPUT
------
ENO   ENAME     ESAL
1     PRAKASH   35000
2     SREE      25000

MAPPING LOGIC
--------------

SRC -----> AGG -----> TGT

Use First Function in Aggegrator to convert the Column to 
rows

In Aggegrator, Create two output columns and write the 
following expression

Port Name  Expression
---------  ----------
O_ENAME   FIRST(COL_VAL,COL_HDR='ENAME')
O_ESAL   FIRST(COL_VAL,COL_HDR='ESAL')

Please get back to me in case of queries.

Thx & Regards,
Prakash Chandran
 
Is This Answer Correct ?    1 Yes 0 No
Prakash Chandran
 

 
 
 
Other ETL Interview Questions
 
  Question Asked @ Answers
 
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.  1
when should one create lookup transformation ?  1
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks  1
Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com NexGen34
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.  2
what is the difference between OLTP database and data warehousing database?  1
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.  1
what are the different forms of normalization?  1
if u can't find what you are looking for in lookup table, how do you handle?  1
what is the difference between normal & bulk loading? and which one is recommended ? why?  1
what are the facilities provided by OLAP to analytical users?  1
Eliminating of duplicate records without using dynamic lookups  1
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)  1
without using ETL tool can u prepare a Data warehousing and maintaining?  1
Eliminating of duplicate records without using dynamic lookups IBM2
what is the indicator file and where it is used?  1
how do u automate Extraction process?  1
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.  1
what is SMP AND MPP?  1
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?  1
 
For more ETL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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