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.

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

---

How do you take care of security using a repository manager

2 Answers  

---

How can u stop a batch?

2 Answers  

---

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

What is meant by target load plan?

0 Answers  

---

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

---

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

what is semi-additive fact?where did u used?

2 Answers  

---