Answer / rekha

1. GET A REALTED VALUE
2.UPDATE SLOWLY CHANGING DIMENSION
3.PERFORM CALCULATIONS

Answer / swetha

To perform the following tasks.

Get a related value. For example, if your source table
includes employee ID, but you want to include the employee
name in your target table to make your summary data easier
to read. Perform a calculation. Many normalized tables
include values used in a calculation, such as gross sales
per invoice or sales tax, but not the calculated value (such
as net sales). Update slowly changing dimension tables. You
can use a Lookup transformation to determine whether records
already exist in the target.

What are the tasks that source qualifier performs?

1 Answers  

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,

---

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

---

What is olap (on-line analytical processing?

0 Answers  

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

Explain reference cursor?

1 Answers  

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

Explain what are the different versions of informatica?

0 Answers  

---

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---