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
- 30025 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 different etl testing categories as per their function?
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.
Explain and compare etl & manual development?
what is pmrep command?
what is the difference steps for data modeling?
What are the types of Data Warehouse applications?
Mention few test cases and explain them?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Give the benefits of data integration suite?
what are the facilities provided by data warehouse to analytical users?
what is the difference between cardinality and Nullability?
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.
How to increase performance without changing anything in mapping.( In prod)
Identifying the bottlenecks in various components of Informatica and resolving them.
what is the main role of FI on business
