I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
- 6 Answers
- 10203 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
SeqFile---->Tranfrmr----->TGT
in Seq file we can add 'ROW NUMBER COlumn' as ROW_NUM which will numbers to each row.
we add 2 parameters to the job: RowNum1, RowNum2
in transformer, in the constrain we can specify below condition:
ROW_NUM<>RowNum1 OR ROW_NUM<>RowNum2
then we can skip those two records.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How do you start developing a datastage project?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is meta stage?
Describe stream connector?
What is a merge in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
Have you have ever worked in unix environment and why it is useful in datastage?
Define oconv () and iconv () functions in datastage?
How and where you used hash file?
What are the benefits of datastage?
Can you explain players in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is the difference between operational data stage (ods) and data warehouse?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How do you run datastage job from the command line?
