Answer / ahalya inturi

constraint based load order defines the order in which data
loads into the multiple targets based on primary key and
foreign key relationship.

Answer / chandrasekar

The above answer with add one point we can configure the
constraint based load order in the Session Config obj tab.

Describe two levels in which update strategy transformation sets?

1 Answers  

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

---

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

---

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

---

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

---

what is SDLC way of code development?

0 Answers  

---

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

---

What all join we can perform in LOOKUP transformation?

0 Answers  

---