Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

Differentiate between Load Manager and DTM?

2215


What are the different clients of powercenter?

1117


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.

2250


in reporting we add some new objects,how we get the count of the newly added objects to the report

2251


can anyone explain me about retail domain project in informatica?

8002


How big was your fact table

1864


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2072


What is flashback table ? Advance thanks

1998


Write the different tools in the workflow manager?

1119


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

2201


What is decode in informatica?

1255


Did u used latest transformations of 8.6.0? for what?

1926


What are the settings that you use to configure the joiner transformation?

1104


How to load data in informatica ?

1070


What is the function of aggregator transformation?

1137