Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Can we write to_date(three arguments) ? Will it work ?
Advance thanks



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

Post New Answer

More Informatica Interview Questions

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,


what is parameter file?

1 Answers   Cap Gemini,


What is sequence generator transformation in informatica?

0 Answers  


wat are deployement groups in informatica, how it will be used for developers

0 Answers  






The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,


What is decode in informatica?

0 Answers  


Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,


lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,


In informatica workflow manager, how many repositories can be created?

0 Answers  


differences between service based and product based?

0 Answers   Satyam,


What is dimensional table? Explain the different dimensions.

0 Answers  






Categories