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
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
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
what is pmrep command?
Explain about the data integration suite features?
Explain etl mapping sheets?
what are the concerns of OLTP and DSS systems?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
what is session partitioning?
Explain the difference between etl tool and olap tools?
what do u do when DB time takes more?in sap bi
what are the cubes developed in a sap bw project and what is the requirement for developing it?
What do you understand by the term ‘transformation’?
Explain what is etl process? How many steps etl contains explain with example?
tell me few points when u become TL
Explain do we need an etl tool?
What is etl process?