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')

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

How to recover sessions in concurrent batches?

3 Answers  

---

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 the functionality of update strategy?

2 Answers  

---

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  

---

Insert else update option in which situation we will use

4 Answers   HCL,

---

What are the performance considerations when working with aggregator transformation?

0 Answers  

---

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

4 Answers   HCL,

---

what is the gap analysis?

1 Answers  

---

Enlist some properties of sessions.

0 Answers  

---

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?

9 Answers   Cap Gemini,

---