Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7350 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
Explain the use lookup tables and Aggregate tables?
Two default user groups created in the repository are____and_____.
where we cannot use sorter Transformation. if we use then we will not get correct data?
what is different between sequential batch and concurrent batch and which is recommended and why?
how do use session mapping parameters ?(in which transformation)
What are the modules in Power Mart?
What is meant by incremental load?
How many steps etl contains explain with example?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
when will use SQL override in a lookup transformation?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Do we need an etl tool?
What is full load & incremental or refresh load?
How to delete data which is not in source table?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
