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 are the different tools in workflow manager?

1 Answers  

---

Mention few power centre client applications with their basic purpose?

1 Answers  

---

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

---

What happens when a session fails and you click on recover?

1 Answers  

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1 Answers  

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

---

What does role playing dimension mean?

1 Answers  

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

1 Answers   Zensar,

---