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

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,

---

How to elaborate powercenter integration service?

0 Answers  

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

---

What are connected or unconnected transformations?

0 Answers   Informatica,

---

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

---

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

---

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

How to delete the data in the target table after loaded.

3 Answers   TCS,

---

What is a difference between complete, stop and abort?

0 Answers  

---

tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,

---