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

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

More Informatica Interview Questions

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  


What is the Rank index port in Rank transformation?

0 Answers   Informatica,


What is DR strategy for Informatica project?

0 Answers  


Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,






one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,


can you avoid static cache in the lookup transformation? I mean can you

1 Answers  


How can one identify whether mapping is correct or not without connecting session?

0 Answers  


Differentiate between joiner and lookup transformation?

0 Answers  


Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,


If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,


Categories