Answer / Chhaya Singh

The number of keys you can define in a remove duplicates stage depends on the ETL tool or programming language being used. Generally, it allows defining one or more keys based on specific columns to identify and eliminate duplicated rows.

What is a delta record? How you will read it?

0 Answers   EDS,

---

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers   TCS,

---

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  

---

How we can convert rows to columns in datastage?

4 Answers   IBM,

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

What are constraints and derivations?

1 Answers  

---

Differentiate between datastage and datastage tx?

1 Answers  

---

What are the areas of application?

1 Answers  

---

How can one find bugs in job sequence?

1 Answers  

---

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

---

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

1 Answers   Infosys, TCS,

---