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 |
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
What are limitations of joiner transformation?
How to recover sessions in concurrent batches?
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 the functionality of update strategy?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
Insert else update option in which situation we will use
What are the performance considerations when working with aggregator transformation?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
what is the gap analysis?
Enlist some properties of sessions.
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?