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
- 7212 Views
- I also Faced
- E-Mail Answers
Answer Posted / kal
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 |
Post New Answer View All Answers
What are the key benefits of ETL Testing?
What is the difference between Data Warehousing and Data Mining?
what are the concerns of OLTP and DSS systems?
how many steps are there in etl process?
What is etl process? How many steps etl contains?
What is staging area referring to?
In Which Transformation We Can Use Having Clause In Informatica?
When do we analyze the tables?
what is the meaning of upgradation of Repository?
What are the different etl testing categories as per their function?
What is a mapping?
What is a staging area? What is the purpose of a staging area?
What are the etl testing operations includes?
What is cube grouping?
What is full load & incremental or refresh load?
