Hello all,
Source Table(Flat File):- Target Table(Flat File):-
Date Date
01/08/2008(DD/MM/YYYY) 01/08/2008
02/08/2008
03/08/2008
04/08/2008
05/05/2008
My requiremnt is this. I need to do it by informatica,Plz
tell me how can i do it?
Thanks
Answers were Sorted based on User's Feedback
The simplest thing U can do is
while importing the source flatfile using "Flat File Import
Wizard"
In Step1 choose-> FixedWidth
in the step2 -> click and create a column or tab on the
field then U can import them as 2 fields
1. 01/08/2008
2.(DD/MM/YYYY)
U can ignore the second column and use the first one.
second method is by taking only the date value in
Expression Transformation.
Hope this of any help
Kal
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / kuttu
if you require only 5 rows in the target we can use 5
target aliases and acheive it.
Is This Answer Correct ? | 0 Yes | 1 No |
what is a worklet?
Explain and compare etl & manual development?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What are the new features of informatica 9 version?
how do u set partition points in the mapping?
what are Lookup caches options? Including persistent caches.
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
how do use session mapping parameters ?(in which transformation)
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Can there be sub steps of etl steps?
what are the data modeling tools you have used?(polaris)
What is the difference between project backlog and product backlog?