Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7044 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 are some examples of informatica etl programs?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the way to execute pl/sql script using informatica mapping?
What is a predefined event?
What if the source is a flat-file?
define galaxy repository in informatica
Explain in detail about scd type 1 through mapping.
What is an Integration service in Informatica?
What all are steps in up gradation of Informatica server?
Is it possible to revert a global repository to local one and why?
What is lookup change?
r u done any partitions in ur project?
What is the cumulative sum and moving sum?
COM components can be used in Informatica
tell me the rules and responsblites in our project(my project is development)
