What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?

1 Answers   TCS,

---

Have you used Unstructured data?

0 Answers   CTS,

---

What is datastage engine?

0 Answers  

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

difference between server shared container and parallel shared container

6 Answers   CTS,

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

---

How do u convert the columns to rows in datastage?

0 Answers  

---

How to Remove Duplicate using SQL?

0 Answers   CTS,

---

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

---

How to reverse the string using SQL?

0 Answers   CTS,

---

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  

---