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
7163 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

Identifying the bottlenecks in various components of Informatica and resolving them.

2606

Which transformation we use to convert 'NA' to 'Not Available'

1257

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

3008

Can there be sub steps of etl steps?

1003

What is full load & incremental or refresh load?

1192

how to connect to a flatfile through ftp in informatica

14265

What are snapshots?

968

what is pmrep command?

11546

What is etl process?

918

Explain different types of partitioning?

1011

How etl testing is different from database testing?

1020

What is partitioning? Explain about round-robin, hash partitioning.

935

what is pmrep command?

2413

How to delete data which is not in source table?

1325

Is hadoop a etl tool?

924