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
Describe expression transformation?
What does command task mean?
Different sorts of metadata that stores in the storage facility?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to differentiate between the active and passive transformations?
What is sequence generator transformation in informatica?
Explain in detail about scd type 1 through mapping.
where to store informatica rejected data?
What is a code page?
Quickly characterize reusable change?
What is the reusable transformation?
What is target load order?
What the difference is between a database, a data warehouse and a data mart?
What is the maplet?
Define filter transformation?