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
Differentiate between Load Manager and DTM?
What are the different clients of powercenter?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
in reporting we add some new objects,how we get the count of the newly added objects to the report
can anyone explain me about retail domain project in informatica?
How big was your fact table
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is flashback table ? Advance thanks
Write the different tools in the workflow manager?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is decode in informatica?
Did u used latest transformations of 8.6.0? for what?
What are the settings that you use to configure the joiner transformation?
How to load data in informatica ?
What is the function of aggregator transformation?