source file contains 100 records, i want 10 records in
target file how it possible in datastage
Answers were Sorted based on User's Feedback
Answer / rajesh
Hi This is Rajesh...By using Tail also we can get last 10 records
| Is This Answer Correct ? | 11 Yes | 2 No |
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 |
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 |
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 |
Answer / chandu
while running prompt put 10 rows.
then the job terminates after 10rows in target
| Is This Answer Correct ? | 4 Yes | 3 No |
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
How do you register plug-ins?
Difference between JOIN,LOOKUP,MERGE?
What is ds designer?
What are the prerequisites for join stage
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
how to call sequential generator in datastage?
how to do pergformence tuning in datastage?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
i want job aborted after some records are loaded into output by using only sequential stage and dataset