first u use sequence generator for the flat file,after that we take rank t

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?

Question Posted / venky

3 Answers
9868 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / venky

first u use sequence generator for the flat file,after that
we take rank transformation in that take top as 50 records
and run the session 4 times it gives 200 records.

Is This Answer Correct ?

1 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is use of SDR function?

5128

What are the different kinds of views available in a datastage director?

973

What are the types of containers?

1142

What is oci?

1259

Describe the main features of datastage?

1039

What is the difference between validated and compiled in the datastage?

1195

what is ds administrator used for?

1113

What is the difference between operational data stage (ods) and data warehouse?

1178

How to read the length of word in unix?

1313

Explain ibm infosphere information server and highlight its main features?

1037

How to reverse the string using SQL?

1427

Name the different types of Lookups in Datastage?

1214

What are the primary usages of datastage tool?

1018

whom do you report?

1881

What are iconv and oconv?

1182