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 is substr in informatica?
What does command task mean?
How to Create a folder using pmrep command?
What is an active transformation?
Difference between Target-based loading and constraint-based loading?
What are the types of data warehouses?
Describe data concatenation?
What is parallel processing in informatica?
what is unit testing?tell me proceedure
Explain what transformation and how many are there in informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
What is the use of target designer?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a rank transform?