Answer / srinu

The Dimension table which is shared by more than one fact
table is called confirmed dimension
Eg: Time Dimension

The fact table which doesn't have any fact information is
called factless fact table

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

---

A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

3 Answers   IBM,

---

What is job control?

0 Answers  

---

When we will go for Data elements?

3 Answers   TCS,

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

specify data stage strength?

1 Answers  

---

What is a quality stage in datastage tool?

0 Answers  

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

2 Answers   Wipro,

---

What is audit table?

1 Answers  

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

---