Answer Posted / maruthi

LOOK UP TABLE IS A REFERENCE TABLE IN WHICH WE WILL PASS A
KEY COLUMN FROM SOURCE TABLE AND WE WILL GET THE REQUIRED
DATA ONCE THE KEY COLUMN MATCHES.

Why do we use exception activity in Datastage?

1367

---

On which Dimension Table you implemented SCD Type in your Project

2110

---

Nls stands for what in datastage?

1228

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2778

---

What are stage variables?

1250

---

What is the difference between operational data stage (ods) and data warehouse?

1292

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3808

---

how can we create rank using datastage?what is the meaning of rank?

8846

---

whom do you report?

1981

---

Define Data Stage?

1138

---

Can you implement SCD2 using join, transformer and funnel stage?

1601

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3693

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

976

---

which r the connectors used in san?

2226

---

What are transforms and what is the differenece between routines and transforms?

1103

---