Can we write to_date(three arguments) ? Will it work ?
Advance thanks
Answer Posted / pandu
ALTER SESSION SET NLS_TERRITORY = 'INDIA';
SELECT TO_DATE(
'January 15, 1989, 11:00 A.M.',
'Month dd, YYYY, HH:MI A.M.',
'NLS_DATE_LANGUAGE = INDIA')
FROM DUAL;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to call shell scripts from informatica?
What is lookup transformation?
What are the issues you have faced in your project? How did you overcome those issues?
How to configure mapping in informatica?
What is a mapplet/worklet in informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Why is sorter an active transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Is stop and abort are same in informatica?
How to do unit testing in informatica?
What is mapplet in informatica?
What is difference between a gateway node and worker node?
What is the difference between STOP and ABORT options in Workflow Monitor?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is lookup change?