Answer Posted / reddymkl.dwh

right(str("0",3):source_data,3)

Differentiate between operational datastage (ods) and data warehouse?

1115

---

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

1172

---

Explain ibm infosphere information server and highlight its main features?

1033

---

Can you explain engine tier in information server?

1061

---

How complex jobs are implemented in datstage to improve performance?

959

---

What are the various kinds of the hash file?

1094

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1331

---

explain about citrix scheduling tool in datastage

2376

---

table actions available in oracle connector?

1554

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2002

---

whom do you report?

1879

---

What are the types of hashed files in data stage

1057

---

Notification Activity

1346

---

Is it possible to query a hash file?

1950

---

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.

3965

---