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
- 7213 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 do you manage the Parameter files while migrating your data from one environment to another environment?
How to generate sequence numbers without using the sequence generator transformation?
What is an unconnected transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
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
Is it possible to define a single node as a Gateway node as well as worker node?
How can we create index after completion of load process?
Have you worked with/created Parameter file
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
In which transformation you cannot drag ports into it?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the different options available for update strategy?
Under which circumstances, informatica server creates reject files?
What are the types of data warehouses?
Explain the informatica workflow?
