Interested to Buy Any Domain ? << Click Here >> for more details...
source file contains 100 records, i want 10 records in
target file how it possible in datastage
- 6 Answers
- 24477 Views
- IBM, I also Faced
- E-Mail Answers
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 |
How you can fix the truncated data error in datastage?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
Differentiate between operational datastage (ods) and data warehouse?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
How rejected rows are managed in datastage?
how to do pergformence tuning in datastage?
What is the roundrobin collector?
what is the main difference between sorragate key n primary key in one word
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Teradata 
