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
- 11846 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
I have a flat file, want to reverse the contents of the flat file
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to load data in informatica ?
What is rank index in rank transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is aggregate cache in aggregator transformation?
have u done any performance tuning? how u ll do?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain pushdown optimization $pushdownconfig parameter - informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain direct and indirect flat file loading (source file type) - informatica
How can a transformation be made reusable?
What could be the possible resons of locks by user?
How to extract the informatica rejected data?
