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 >> ETL
  2. Suggest New Category

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

Question Posted / ramarao

Answer Posted / ramarao

Hi Friends,

I think this possible by using source Qualifier ALSO.

The Senario is

Issue_id,Question,Answer
100,1,y
100,2,n
100,3,y
100,4,n

Target is issue_id,Answer1,Answer2,Answer3,Answer4
100, y,n,y,n

This can be Achived by using source Qualifier And joiners.
There is no need to use Normaliser.

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a materialized view log?

992

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2033

Explain about etl data integration software?

881

Explain about hash partitioning?

990

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1960

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1947

What is the difference between Data Warehousing and Data Mining?

1046

What are the differences between sql override and update override?

1094

What is Data Vault???

2739

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2349

what are the concerns of OLTP and DSS systems?

1959

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

947

what are the concerns of OLTP and DSS systems?

2442

What is staging area referring to?

1126

What are the types of Data Warehouse applications?

1016