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
- 9 Answers
- 29718 Views
- Infosys, I also Faced
- E-Mail Answers
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
What are the three tiers in etl?
what is an ETL or ETT? And what are the different types?
Define Dynamic push down optmization?
tell me few points when u become TL
What are the different etl testing categories as per their function?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Is apache nifi an etl tool?
What is etl process. How many steps etl contains explain with example?
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.
Mention few test cases and explain them?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
List few etl bugs?
what is session partitioning?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
