My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101

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

Question Posted / rakeshm4119

3 Answers
6147 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I w..

Answer / vijaya

by using normalizer transformation we can done it.

sq-> ex,-> norm-> tgt

if you want clear answer u check tmrw this question

Is This Answer Correct ?

4 Yes

0 No

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I w..

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

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I w..

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