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

How to do unit testing in informatica?

0 Answers  

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

In Which scenario did u used Incremental loading?

2 Answers  

---

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  

---

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

lookup transformation with screenshots

0 Answers   TCS,

---

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

---

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

---

What are reusable transformations in how many ways we can create them?

2 Answers  

---