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 / rakesh
Thanks Vijaya.
In Expression we can use the date function to find the week number of the year. But here we have 1-nov-2011 as the column name, but not the column value. i.e; we have dates as column names, not as col values..
So please clarify..
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain about Informatica server process that how it works relates to mapping variables?
Define filter transformation?
what are the Methods For Creating Reusable Transformations?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is a shortcut and copy in Informatica and how two are different with each other?
Explain what is informatica metadata and where is it stored?
What does cheating measurement mean?
Enlist the tasks for which source qualifier transformation is used.
What's the layout of parameter file (what does a parameter file contain?)?
Explain how many types of dimensions are available in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Is it possible to use a client with different version than that of its Informatica server?
What are the new features of Power Center 5.0?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?