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
Could you explain what is enterprise data warehouse?
Can we create a Integration service without a Repository service and vice versa?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
pmscmd startworkflow -sv
Is it possible to revert a global repository to local one and why?
Where are the source flat files kept before running the session?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Is there any target staging area in informatica not staging area
What is the function of union transformation?
What is lookup change?
Explain pushdown optimization $pushdownconfig parameter - informatica
How will the document be delivered to me?
What are the differences between joiner transformation and source qualifier transformation?
What is meant by LDAP users?