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
7096 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 session parameters? How do u set them?

1997

What do you understand by active and passive transformations?

900

how do u really know that paging to disk is happening while u are using a lookup transform?

1945

Is hadoop a etl tool?

896

how to load the data to fact table?

2664

In Which Transformation We Can Use Having Clause In Informatica?

1185

what is the difference between cubes and package in cognos

4908

what happens if the info.server doesn't find the session parameter in the parameter file?

1892

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

1235

Do we need an etl tool?

956

What is a materialized view log?

960

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2185

can be used COM component in Informatica ?

2029

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1730

Do we need an ETL tool? When do we go for the tools in the market?

906