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


Please Help Members By Posting Answers For Below Questions

Could you explain what is enterprise data warehouse?

646


Can we create a Integration service without a Repository service and vice versa?

835


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1735


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1163


Is it possible to revert a global repository to local one and why?

717






Where are the source flat files kept before running the session?

721


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

706


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1621


Is there any target staging area in informatica not staging area

2230


What is the function of union transformation?

713


What is lookup change?

699


Explain pushdown optimization $pushdownconfig parameter - informatica

812


How will the document be delivered to me?

706


What are the differences between joiner transformation and source qualifier transformation?

725


What is meant by LDAP users?

776