Answer / abdul

can we use GET_DATE_PART Function?

Answer / abhinaw prakash

We can use Date Conversion function to find out the Year and
use SUBSTR function to extract that particular year.

Answer / ram

use TO_DECIMAL(TO_CHAR(COLUM,'YYYY'))

Answer / ganesh reddy

use expression t/r in exp write to_char(hiredate,'yyyy')

what is datamart

4 Answers   IBM, Informatica,

---

What is the difference between OLTP and ODS?

4 Answers  

---

what is scd?

6 Answers  

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

---

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

---

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

---

What are the active and passive transforamtions?

2 Answers  

---

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

---

Explain sessions?

0 Answers  

---