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 / 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 |
Post New Answer View All Answers
What does reusable transformation mean?
Define mapplet?
Explain transaction control transformation in informatica
What is a code page?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is repository manager?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to go to the older version for a mapping?
What is Cognos script editor?
lookup transformation with screenshots
Differentiate between a repository server and a powerhouse?
How can we remove the duplicates from flat file source?
Explain Dataware house architecture .how data flow from intial to end?