A mapping contains
(1) Source Table S_Time ( Start_Year, End_Year )
(2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Answer / pati
Day = to_char(sysdate,'Day')
Date = to_char(sysdate,'DD')
Month = to_char(sysdate,'Month')
Year = to_char(sysdate,'YYYY')
Quater = to_char(sysdate,'Q')
| Is This Answer Correct ? | 3 Yes | 2 No |
how to join two flat files in informatica?
How to identify this row for insert and this row for update in dynamic lookup cache
what are presession,postsession success and postsession failure commands ?
can we load the data with out a primary key of a table? what is target plan?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
tell me 5 session failure in real time how can you solve that in your project?
wf dont have integration severances how you can run?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Define sessions in informatica etl?
What is a surrogate key?
What are the session parameters?
what is worklet and what use of worklet and in which situation we can use it?