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
- 9773 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 is an Integration service in Informatica?
Define the various join types of joiner transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
How to partition the Session?
What is an unconnected transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What do you mean by worklet?
What is the benefit of partitioning a session?
How to elaborate powercenter integration service?
How can you generate reports in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the procedure for creating independent data marts from informatica 7.1?
Differentiate between router and filter transformation?
Did u used latest transformations of 8.6.0? for what?
