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
- 7081 Views
- Wipro, I also Faced
- E-Mail Answers
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
Is it possible to revert a global repository to local one and why?
Explain what transformation and how many are there in informatica?
What are mapplets?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the types of caches in lookup? Explain them.
What is sq transformation?
Explain scd type 3 through mapping.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How will the document be delivered to me?
Slowly changing dimensions, types and where will you use them
Explain lookup transformation source types in informatica
What is rank transformation in informatica
What is the meaning of up gradation of repository?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the use of source qualifier?
