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
- 24160 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 are the various kinds of containers available in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
how to change left and right links in join stage?
Could anyone give brief explanation bout datastage admin
explain unit testing,systemtesting,integrated testing
where we use column generator stage in real time scenario?
Define project in datastage?
What is the difference between hashfile and sequential file?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
how to remove duplicates in transformer stage by using stage variables?one example?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Can you implement SCD2 using join, transformer and funnel stage?
Teradata 
