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
- 24389 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 many types of stage?
What is "fatal error/rdbms code 3996" error?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the areas of application?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
How can we run same job in 1 day 2 times
What is use Array size in datastage
Does datastage support slowly changing dimensions ?
How will you move hashed file from one location to another location?
What is the difference between hashfile and sequential file?
What is the difference between SQl Loader and OCI in datastage?
Where do the datastage jobs get stored?
Teradata 
