A flatfile contains 200 records.I want to load first 50 records at first time r

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 / prasad

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

Answers were Sorted based on User's Feedback

A flatfile contains 200 records.I want to load first 50 records at first time running the job,secon..

Answer / srinu

flat file nothing but take sequence file use sed -n '1,50p'
using this command in filter option in the first running job.
second running job we use sed -n '51p,100' using this command
in this way we use other two times running job.....

Is This Answer Correct ?

8 Yes

1 No

A flatfile contains 200 records.I want to load first 50 records at first time running the job,secon..

Answer / vamsi

hi,
where we can get the rank function in datastag....

Is This Answer Correct ?

0 Yes

0 No

A flatfile contains 200 records.I want to load first 50 records at first time running the job,secon..

Answer / 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

More Data Stage Interview Questions

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers IBM,

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers Infosys,

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers IBM,

What are the types of views in datastage director?

0 Answers

Difference between JOIN,LOOKUP,MERGE?

2 Answers CTS,

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

1 Answers IBM,

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers Accenture,

how can u find out the datastage job is running on how many nodes

7 Answers IBM,

How do you register plug-ins?

0 Answers

INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

11 Answers CTS,

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers

For more Data Stage Interview Questions Click Here