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 |
What is the difference between Active and Passive transformation?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
What is CDC? How to implement CDC?
Differentiate between a database and data warehouse?
tell me the push down optimization
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
How do you manage the Parameter files while migrating your data from one environment to another environment?
how we can do session partition in informatica any one explain me clearly? thanks advance.
Mention some types of transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Enlist the advantages of informatica.
can we use cartesian join in informatica