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 / yamini

Hi,

we can pass the date values in mapping parameter. why because as the column values are constant so we can pass that values in expression by creating output ports.

So after exp transformation put a normalizer with occurrence 2. after normalizer put an exp to convert date into week by to_char function

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the commit type if you have a transaction control transformation in the mapping?

973


What do you mean by channel change?

967


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3818


What is a pre-defined event and user-defined event?

976


What are the uses of etl tools?

1069


Difference between Data and Index Caches?

1096


wf dont have integration severances how you can run?

1887


How to use procedural logic inside infromatica?

1139


What is blocking transformation?

1084


How to generate sequence numbers without using the sequence generator transformation?

1116


what is diff b/t sorter t/r and agg have the option sorter property...

2134


How would you join a node to the already existing domain?

1068


What is the use of an aggregator cache file?

1144


To import the flat file definition into the designer where should the flat file be placed?

1008


Why filter transformation is an active one?

932