Answer Posted / bharath

SERVER JOBS
->Runs on single node
->Executes on DS Server Engine
->Handles less volume of data
->Slow data processing
->Having less no. of components(i.e, palette)
->Compiled into Basic language.

PARALLEL JOBS
->Runs on multiple nodes.
->Executes on DS parallel engine.
->Handles Huge volume of data
->Faster data processing.
->Having more no. of components
->Compiled into OSH(orchestrate shell script) except transformer( C++ and OSH )

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

3465

---

What is the differentiate between data file and descriptor file?

1367

---

What are the components of datastage?

1127

---

What is ds designer?

1109

---

what are the errors,warnings in datastage

2706

---

How do you remove duplicate values in datastage?

1158

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2815

---

Explain entity, attribute and relationship in datastage?

1112

---

Difference between data warehousing and olap?

1097

---

How to Remove Duplicate using SQL?

1373

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

781

---

Demonstrate experience in maintaining quality process standards?

2561

---

How complex jobs are implemented in datstage to improve performance?

1047

---

What are sequencers?

1124

---

Is it possible to query a hash file?

2018

---