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

Explain etl mapping sheets?

1082

what is pmrep command?

11586

Explain about enterprise scalability and roi of data integration suite?

881

Explain etl?

987

Explain and compare etl & manual development?

926

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1810

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

968

What is etl process. How many steps etl contains explain with example?

961

SCD2 will work on only dimension tables as well as fact Table?

1401

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1895

What are the steps involved in etl process?

1030

Explain different types of partitioning?

1043

what are the reports developed in sap bw project and what is the requirement for developing it?

2180

How to fine tune mappings?

943

What are the different etl testing categories as per their function?

1078