Answer / chandu

audit table is nothing but when the job is developed,how many no of stages are used,each stage having how many no of input records are there also how many no of out put records are there,job start date,job end date etc these information having audit table

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

0 Answers  

---

How to reverse the string using SQL?

0 Answers   CTS,

---

What is the use of datastage director?

0 Answers  

---

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  

---

What is the importance of the exception activity in datastage?

0 Answers  

---

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

---

how can u connect the client system directly at any time?

1 Answers   IBM,

---

What all are the different way to run a job?

0 Answers  

---

why we use parameters instead of hard code in datastage

4 Answers   HCL,

---

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

1 Answers   Reliance,

---