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
- 10154 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
What are multi-group transformations?
draw informatica architecture 8.6 ?
What is the sequence generator transformation in informatica?
Can we create a Integration service without a Repository service and vice versa?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What you know about transaction control transformation?
What is the need for an etl tool?
What can we do to improve the performance of informatica aggregator transformation?
What is meant by LDAP users?
What is the need of etl tools?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Where are the source flat files kept before running the session?
How do you manage the Parameter files while migrating your data from one environment to another environment?
State the differences between sql override and lookup override?
What is the use of transformation?
