Answer Posted / srikanth

Hi this is srikanth, A fact table consists of the
measurements, facts of a business process.
Dimension table consists descriptive or meaningful
information of business process.

how to export or import the jobs in .ISX file

1254

---

What are the types of containers in datastage?

1226

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4098

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2288

---

How do you import and export the datastage jobs?

1211

---

What is a ds designer?

1115

---

What are the types of containers and how to create them?

1023

---

What are the partitioning techniques available in link partitioner?

2330

---

What is the difference between datastage and datastage tx?

1117

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2212

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

970

---

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

1113

---

What are the difference types of stages?

1287

---

How to find value from a column in a dataset?

2253

---

What is the difference between odbc and drs stage?

1137

---