hi,there is a scenario like.
there are three columns empid,salmonth, sal contains the values 101,jan,1000
101 feb 1000 like twelve rows are there then my required out put is like
contains 13 columns empid jan feb marc.......dec and the velues are
101 1000 1000 1000 like this . thank you
Answer Posted / sujana
use agg->grp by..
and then create 13o/p ports..and give condition for jan sal (iif month=jan,sal)..give appropriate conditions for remainng o/pports also...
crct me if m wrong
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to delete duplicate row using informatica?
What is different between the data warehouse and data mart?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
State the differences between sql override and lookup override?
What are the types of schemas we have in data warehouse.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to load the data from people soft hrm to people soft erm using informatica?
Plz can any one say me how to get the informatica certification materials and dumps
What are the guidelines to be followed while using union transformation?
Mention few power centre client applications with their basic purpose?
Repository user profiles
What are batches?
my source is junk data how will u remove that junk data by using unix please any one replay me
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?