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...

Which type or t/s is used to convert rows into column &
column into rows

Answer Posted / sowjanya

Using BODS 3.2 or higher versions

To convert columns to Rows : PIVOT transform

To convert rows to coulums : REVERSE PIVOT transform

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where is the cache (lookup, index) created and how can you see it.

2011


what is the meant by Normalization and de-normalization?

2710


What is a lookup table in etl?

1178


Explain the key challenges that you face while performing etl testing.

1000


Explain and compare etl & manual development?

918


can cubes contain measures ?

2021


what is Forward,Reverse and Re_engineering?

2191


Explain the difference between etl tool and olap tools?

900


Explain about hash partitioning?

987


1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

2236


Explain the use lookup tables and Aggregate tables?

967


What is lookup table in etl testing?

1174


how do u really know that paging to disk is happening while u are using a lookup transform?

2421


What is a staging area? What is the purpose of a staging area?

879


Can there be sub steps of etl steps?

1012