Can we write to_date(three arguments) ? Will it work ?
Answer / pandu
ALTER SESSION SET NLS_TERRITORY = 'INDIA';
'January 15, 1989, 11:00 A.M.',
'Month dd, YYYY, HH:MI A.M.',
'NLS_DATE_LANGUAGE = INDIA')
|Is This Answer Correct ?||3 Yes||1 No|
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
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
what is parameter file?
What is sequence generator transformation in informatica?
wat are deployement groups in informatica, how it will be used for developers
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is decode in informatica?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
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?
In informatica workflow manager, how many repositories can be created?
differences between service based and product based?
What is dimensional table? Explain the different dimensions.