Can we write to_date(three arguments) ? Will it work ?
Advance thanks
Answer / 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 |
How to generate sequence numbers using expression transformation?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
what is Partitioning ? where we can use Partition?
How to list Top 10 salary, without using Rank Transmission?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
what is the -ve test case in your project.
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
how do u use sequence created in oracle in informatica? Explain with an simple example
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500