source file contains 100 records, i want 10 records in target file how it pos

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

source file contains 100 records, i want 10 records in
target file how it possible in datastage

Question Posted / datastage38

6 Answers
24168 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / vamsi

take source --->trf---->trg
in transformer constaints put inrownum <=10
then u can get the required answer.........

Is This Answer Correct ?

15 Yes

2 No

source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / rajesh

Hi This is Rajesh...By using Tail also we can get last 10 records

Is This Answer Correct ?

11 Yes

2 No

source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / alok

At source stage properties (I'm assuming Sequential File Stage is used), go to the Filter option in properties tab and type head -10. The sq file stage will read only top 10 records and ignore the rest.

Is This Answer Correct ?

11 Yes

4 No

source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / radha guntupalli

If you want top ten records In seq file_options_filter-
head -10.For last 10 records tail -10.

Is This Answer Correct ?

6 Yes

2 No

source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / snehasis

By using read first rows option in sequential file stage we can get 10 records out of 100 records of a file

Is This Answer Correct ?

3 Yes

0 No

source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / chandu

while running prompt put 10 rows.

then the job terminates after 10rows in target

Is This Answer Correct ?

4 Yes

3 No

Post New Answer