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
- 3 Answers
- 6146 Views
- Wipro, I also Faced
- E-Mail Answers
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 are the issues you have faced in your project? How did you overcome those issues?
What is the Rank index port in Rank transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is a joiner transformation and why it is an active one?
What is a filter transformation and why it is an active one?
Why do you use Mapping Parameter and mapping variable?
difference between repository database and repository service?
Can you generate sequence numbers without using the sequence generator transformation?
What the difference is between a database, a data warehouse and a data mart?
In warehouses how many schemas are there?
What do you mean by blocking transformation?
What is the difference between a connected look up and unconnected lookup?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Tell me about Propagate functions in informatica
How many ways a relational source definition can be updated and what are they?
