I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
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
What are the steps needed to create a simple basic datastage job?
how to write server Routine coding?
what is repositery?
How to RD using transformer?
how to export or import the jobs in .ISX file
What is oci?
Which algorithm you used for your hashfile?
What are the different common services in datastage?
Define Job control?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
AGGREGATOR default datatype
What is the method of removing duplicates, without the remove duplicate stage?
What is the importance of the exception activity in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Whats difference betweeen operational data stage (ods) and data warehouse?