Answer Posted / varma

As a developer you cannot find it unless you have CREATE_TS column in the table. Its always a best practice to have this column which records timestamp.

DBAs can find out in several ways (Tracing etc) but its not a straight forward way

What are the different type of jobs in datastage?

1043

---

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

2813

---

describe the Steps to confiure a Qlogic switch

2383

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2085

---

How to reverse the string using SQL?

1527

---

What is the difference between the local container and shared container?

1103

---

What is the difference between odbc and drs stage?

1092

---

What is the use of datastage designer?

1154

---

Can you explain engine tier in information server?

1135

---

How many types of sorting methods are available in datastage?

1073

---

How do you reject records in a transformer?

1124

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1390

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

---

How to implement complex jobs in data stage?

1112

---

How do you run datastage job from the command line?

1092

---