Answer Posted / satyanarayana

In this removes the unwanted data(Bad records OR NULL
Values) and find the inconsistent data and make it
consistent data.

Example:

LOc
---
Hyd
Hyderabad
hyde

After Cleansing

Loc
---
Hyderabad
Hyderabad
Hyderabad

Differentiate between operational datastage (ods) and data warehouse?

1116

---

Have you have ever worked in unix environment and why it is useful in datastage?

1083

---

Define ds designer?

1216

---

Describe stream connector?

1245

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1171

---

Does datastage support slowly changing dimensions ?

1053

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3415

---

What is usage analysis in datastage?

1262

---

Name the different types of Lookups in Datastage?

1214

---

What is quality stage?

937

---

Which warehouse using in your datawarehouse

2116

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

953

---

What is datastage engine?

1119

---

How to RD using transformer?

1364

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1440

---