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.

Describe the main features of datastage?

1123

---

What are the important features of datastage?

1197

---

What are the types of hashed files in data stage

1146

---

What is a quality stage in datastage tool?

1127

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2224

---

What are system variables and sequencers in datastage

1177

---

What is a ds designer?

1112

---

What is the flow of loading data into fact & dimensional tables?

1111

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

3018

---

project Steps,hits, Project level HArd things,Solved methods?

2182

---

Explain connectivity between datastage with datasources?

1040

---

How do u convert the columns to rows in datastage?

1243

---

Differentiate between operational datastage (ods) and data warehouse?

1231

---

Why do we use link partitioner and link collector in datastage?

1186

---

What are sequencers?

1172

---