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 souce qualifier transformation it is active or passive

2 Answers   HCL,

---

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

---

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

---

Why touse stored procedure in ETL Application?

2 Answers  

---

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

explain about lookup t/r?

1 Answers   IBM,

---

What is informatica? Why do we need it?

0 Answers  

---

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---