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

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

---

What is PX?

2 Answers   IBM,

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers   Alpharithm Technologies,

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

0 Answers   HCL,

---

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

---

How many Nodes configuration file you used in your last project?

1 Answers  

---

Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,

---

Which algorithm you used for your hashfile?

0 Answers  

---

what is the difference between datasatge and datastage TX?

6 Answers  

---

Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,

---