Interested to Buy Any Domain ? << Click Here >> for more details...
Three date formats are there . How to change these three into
One format without using expression transformation ?
- 3 Answers
- 11769 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / isha_gtb
IIF(IS_DATE(col1,'dd/mm/yyyy'),to_date(col1,'dd-mm-yyyy),NULL)
Is_date to check the format
and to_date to change it to desired format
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Different sorts of metadata that stores in the storage facility?
Explain the shared cache and re-cache?
What are the types of lookup transformation?
Whats there in global repository
how to create user defined function (udf) in informatica
How can we remove the duplicates from flat file source?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is the difference between a connected look up and unconnected lookup?
What are the different types of transformation available in informatica.
If informatica has its scheduler why using third party scheduler?
What is deployment group?
How might you approve all mappings in the archive all the while?
While migrating the data from one environment to another environment how would you manage the connections?
