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 / 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 data movement modes in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain the informatica workflow?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Informatica settings are available in which file?
Tell me about MD5 functions in informatica
What are the uses of etl tools?
How to load the data from people soft hrm to people soft erm using informatica?
Whats there in global repository
Please let me know how to make Data masking in informatica..
What is olap (on-line analytical processing?
Explain pushdown optimization $pushdownconfig parameter - informatica
hi real timers . iam waiting for ur reply regarding ETL TESTING
Write the unconnected lookup syntax?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.