In expression transfromation to_date(datecolumnname,dd/mm/yyyy) and pass

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

Question Posted / bhagya

3 Answers
7210 Views
I also Faced
E-Mail Answers

Answer Posted / bhagya

In expression transfromation
to_date(datecolumnname,dd/mm/yyyy) and pass this link upto
target

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the three tiers in etl?

1113

what are the concerns of OLTP and DSS systems?

1962

what are the facilities provided by data warehouse to analytical users?

2081

Difference between flat files and relational sources?

2239

Explain about enterprise scalability and roi of data integration suite?

877

if i have a query as flat file how can we load data to target table

1398

Explain different types of partitioning?

1041

List few etl bugs?

941

What are dimensions?

1059

how would u estimate the size of Aggregator transform data and index cache?

2413

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1194

What are the differences between sql override and update override?

1100

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2174

what is dynamic insert?

2198

how to load the data to fact table?

2701