Answer / ankit gosain

Hi All,

If you have enabled Run-Time Colum Propagation in your job
and you have created a Schema file, then it doesn't matter
that you define the metadeta in your sequential file or not
because datastage will always take the metadata from the
Schema File. And you'll define the metadata in Seq. file as
well then it will be overwritten at the run time on the
basis of Schema File.

Cheers,
Ankit :)

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

8 Answers   IBM,

---

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

---

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

---

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

---

What is orabulk stage?

0 Answers  

---

---

Explain usage analysis in datastage?

0 Answers  

---

Describe the main features of datastage?

0 Answers  

---

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,

---

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,

---

Does datastage support slowly changing dimensions ?

0 Answers  

---

What are orabulk and bcp stages?

0 Answers  

---

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

---