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 |
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
Can you filter data in hashed file?
what is operator combinality in datastage?
How many number of reject links merge stage can have?
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
How to find value from a column in a dataset?
what are fact tables and dimension tables? give example assuming one table.
what is initial load and incremental load
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Differentiate between odbc and drs stage?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?