Answer Posted / kiran

1.In drvition ,Instead of calling routines implementing
stage variales.
2.while using ODBC Stag,adjust as per row seetings.
3.using user defined queiries while Extract the date from
sorce.
4.minimize null values
5.minimize unused columns
6.minimize warninigs
7.don't use more than 7 look up in a job,if exceede take
another transformer.
8.don't use morethan 20 stages in a job.
9.before loading data drop indexes after re created indexes.
10.worked with DBA-Admin for
11.tuned in Project tunes in Datastage Admin
12
13
14
15
16

How do you remove duplicate values in datastage?

1093

---

Nls stands for what in datastage?

1142

---

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

2002

---

Name the command line functions to import and export the DS jobs?

1090

---

Explain the importance of surrogate key in data warehousing?

1128

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1833

---

Why do we use exception activity in Datastage?

1227

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2382

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2166

---

Differentiate between odbc and drs stage?

997

---

Have you used Unstructured data?

1267

---

What are the functionalities of link partitioner and link collector?

950

---

What is the difference between informatica and datastage?

1146

---

How do you start developing a datastage project?

1057

---

What are the job parameters?

1157

---