Interested to Buy Any Domain ? << Click Here >> for more details...
write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000
- 8 Answers
- 10202 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kamleshmishra291
SELECT * FROM TABLE_NAME PIVOT( MAX(SALES) FOR REGION IN (1,2));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between sessions and batches?
Which files are created during the session rums by informatics server?
How many ways are there to do 'remove duplicate records in informatica'?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What does “tail –f” command do and what is its use as an Informatica admin.
how to load dimension table and fact table. plz tell me the steps.
Explain the tuning lookup transformation - informatica
State the limitations where we cannot use joiner in the mapping pipeline?
What is lookup transformation?
What is the function of aggregator transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is meant by a domain?
What are the transformations that are not supported in mapplet?
What is a snowflake schema?
Explain direct and indirect flat file loading (source file type) - informatica
