My flat file source is
C_Id 1-nov-2011 8-nov-2011
100 2000 1500
101 2500 2000
I want my Target as
C_Id Week_Num Amt
100 45 2000
100 46 1500
101 45 2500
101 46 2000
Answer Posted / rakesh
Thanks Vijaya.
In Expression we can use the date function to find the week number of the year. But here we have 1-nov-2011 as the column name, but not the column value. i.e; we have dates as column names, not as col values..
So please clarify..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Informatica Checkpoints
what is song in infrmatica...?
Explain transaction control transformation in informatica
Is there any way to read the ms excel datas directly into informatica?
Briefly explain the aggregator transformation?
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 is powercenter on grid?
What is a rank transform?
wat are deployement groups in informatica, how it will be used for developers
Design time, run time. If you don't create parameter what will happen
How can you increase the performance in joiner transformation?
Why do you use Mapping Parameter and mapping variable?
How to create the source and target database connections in server manager?
Mention few advantages of router transformation over filter transformation.
What are the prerequisite tasks to achieve the session partition?