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
Explain etl mapping sheets?
what is pmrep command?
Explain about enterprise scalability and roi of data integration suite?
Explain etl?
Explain and compare etl & manual development?
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.
What is partitioning? Explain about round-robin, hash partitioning.
What is etl process. How many steps etl contains explain with example?
SCD2 will work on only dimension tables as well as fact Table?
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?
What are the steps involved in etl process?
Explain different types of partitioning?
what are the reports developed in sap bw project and what is the requirement for developing it?
How to fine tune mappings?
What are the different etl testing categories as per their function?