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
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 |
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 |
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 ‘|’ .
What is the Rank index port in Rank transformation?
What is DR strategy for Informatica project?
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 ?
what is bitmap index? did u use it?and how to use it in informatica
one source to target loading insert new rows and update existing rows?
can you avoid static cache in the lookup transformation? I mean can you
How can one identify whether mapping is correct or not without connecting session?
Differentiate between joiner and lookup transformation?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
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?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?