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
- 3 Answers
- 6142 Views
- Wipro, I also Faced
- E-Mail Answers
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
What is aggregator transformation in informatica?
Tell me about Propagate functions in informatica
What are the new features of Power Center 5.0?
How an expression transformation differs from aggregator transformation?
Differentiate between router and filter transformation?
What do you mean by channel change?
What is update strategy transform?
Is stop and abort are same in informatica?
What is a code page?
Explain the tuning lookup transformation - informatica
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain incremental aggregation in informatica
explain abt ur project architecture?
Explain how to import oracle sequence into informatica?
What do you mean by blocking transformation?
