Answer Posted / varun

Design the job like this:
1. Read records from input flat file and click on option of
rownumbercolumn in the file. It will generate a unique
number corresponding to each record in that file.
2. Use filter stage and write the conditions like this:
a. rownumbercolumn<=50(in 1st link to load the records
in target file/database)
b. rownumbercolumn>50 (in 2nd link to load the records
in the file with the same name as input file name, in
overwrite mode)


So, first time when your job runs first 50 records will be
loaded in the target and same time the input file records
are overwritten with records next first 50 records i.e. 51
to 200.
2nd time when your job runs first 50 records(i.e. 51-100)
will be loaded in the target and same time the input file
records are overwritten with records next first 50 records
i.e. 101 to 200.
And so on, all 50-50 records will be loaded in each run to
the target

How many types of sorting methods are available in datastage?

1114

---

Notification Activity

1457

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1795

---

What is the command line function to import and export the ds jobs?

1189

---

How to RD using transformer?

1472

---

What are the repository tables in datastage?

1349

---

Explain the situation where you have applied SCD in your project?

2086

---

What are the components of ascential data stage?

1240

---

Explain datastage architecture?

1449

---

Where do the datastage jobs get stored?

1268

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2928

---

Why we use surrogate key?

1304

---

whom do you report?

1984

---

How can you write parallel routines in datastage PX?

1065

---

What is staging variable?

1153

---