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
What is the benefit of partitioning a session?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How do you migrate data from one environment to another?
Does an informatica transformation support only aggregate expressions?
Can you use flat files in Mapplets.
How is union transformation utilized?
What are the databases that informatica can connect to windows?
Differentiate between a database and data warehouse?
What is pmcmd command?
Can we override a native sql query within informatica?
How can we delete duplicate rows from flat files?
How we can use union transformation?
Why update strategy and union transformations are active?
how to create user defined function (udf) in informatica