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

 Informatica Checkpoints

3334


what is song in infrmatica...?

2238


Explain transaction control transformation in informatica

1271


Is there any way to read the ms excel datas directly into informatica?

1023


Briefly explain the aggregator transformation?

1011


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628


What is powercenter on grid?

1179


What is a rank transform?

1087


wat are deployement groups in informatica, how it will be used for developers

1720


Design time, run time. If you don't create parameter what will happen

1837


How can you increase the performance in joiner transformation?

1193


Why do you use Mapping Parameter and mapping variable?

1770


How to create the source and target database connections in server manager?

1090


Mention few advantages of router transformation over filter transformation.

1024


What are the prerequisite tasks to achieve the session partition?

1255