Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 10007 Views
- Patni, I also Faced
- E-Mail Answers
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 load the name of the current processing flat file along with the data into the target using informatica mapping?
Describe data concatenation?
How to generate sequence numbers?
What is a filter transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How can you increase the performance in joiner transformation?
Explain about cumulative Sum or moving sum?
What are the types of schemas we have in data warehouse.
What is the surrogate key?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is expression transformation?
Write the different tools in the workflow manager?
how we can load rejected record's at run time?(not through bad files)
What is meant by target load plan?
Please let me know how to make Data masking in informatica..
