Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7230 Views
- I also Faced
- E-Mail Answers
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 session partitioning?
how to load the data to fact table?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
explain the methodology of Data Warehousing?(Polaries)
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
What is partitioning? Explain different types of partitioning?
explain the methodology of Data Warehousing?(Polaries)
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What is the main difference between peek stage and copy stage
what is Forward,Reverse and Re_engineering?
indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
Teradata 
