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
- 6696 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 types of data warehouse applications and what is the difference between data mining and data warehousing?
how does the server recongnise the source and target databases.Elaborate on this
what is pmrep command?
how do u really know that paging to disk is happening while u are using a lookup transform?
if i have a query as flat file how can we load data to target table
what is data modeling?
What is etl tool in hadoop?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is the main role of FI on business
Define Dynamic push down optmization?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
what is pmrep command?
Explain about etl data integration software?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
when will use SQL override in a lookup transformation?
