Answer Posted / kiran

hai..,This is Kiran..,

Common error will get while Extraction ,Transforming and
loading the data into target.

1.Data Type Mismatches(eg:non-numeric field in numeric
field).
2.null values in not null fields.
3.fields size different.
4.data type sizes between sorce to target.

Define meta stage?

1143

---

What is ds designer?

1030

---

What are stage variables?

1139

---

How many types of hash files are there?

1117

---

Is possible to create skid in dim,fact tables?

2587

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2820

---

What are the main features of datastage?

1206

---

What are the various kinds of the hash file?

1095

---

What is the difference between an operational datastage and a data warehouse?

1088

---

Lookup constraints

1200

---

Explain the importance of surrogate key in data warehousing?

1128

---

Why do you need stage variables?

1132

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1224

---

What is staging variable?

1027

---

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

1171

---