Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7099 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
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain the difference between mapping parameter and mapping variable?
What are the measure objects?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is lookup transformation?
What are the tasks that can be performed using sq?
What are some examples of informatica etl programs?
How are the sources and targets definitions imported in informatica designer?
How to update or delete the rows in a target, which do not have key fields?
What are the differences between a connected lookup and unconnected lookup?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to load a Dimension ? and how to load a fact table?
how to load rows into fact table in data warehouse
How big was your fact table
Performance tuning( what you did in performance tuning)
