write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000
Answer Posted / ravi
select * from table_name pivot(sum(sales) for region in(1,2));
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
is it possible to index the data in cache of lkp transformation ?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
Differentiate between source qualifier and filter transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
Explain the pipeline partition with real time example?
draw informatica architecture 8.6 ?
Describe an informatica powercenter?
What is dimensional table?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
which one is better performance wise joiner or look up
What is deployment group?
Design time, run time. If you don't create parameter what will happen
Please let me know how to make encryption and decryption with example?