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
- 24425 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 |
What is a merge?
What is a delta record? How you will read it?
What are data elements?
how can u find out the datastage job is running on how many nodes
what is flow of project?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
in aggregator , how can i get the sum in readable format
What is datastage engine?
How many types of stage?
if ename='subbu' while running job the job should be abort how come?
Teradata 
