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
What is the commit type if you have a transaction control transformation in the mapping?
What do you mean by channel change?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is a pre-defined event and user-defined event?
What are the uses of etl tools?
Difference between Data and Index Caches?
wf dont have integration severances how you can run?
How to use procedural logic inside infromatica?
What is blocking transformation?
How to generate sequence numbers without using the sequence generator transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
How would you join a node to the already existing domain?
What is the use of an aggregator cache file?
To import the flat file definition into the designer where should the flat file be placed?
Why filter transformation is an active one?