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
list out all the transformations which use cache?
What are the different options available for update strategy?
How to open an older version of an object in the workspace?
How we can use union transformation?
How big was your fact table
How to generate sequence numbers using expression transformation?
How are indexes created after completing the load process?
Whats the difference between informatica powercenter server, repositoryserver and repository?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Write the unconnected lookup syntax and how to return more than one column.
What do you mean incremental aggregation?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
how we can load rejected record's at run time?(not through bad files)
whats the logic to load the lower level of granularity of data to fact table.