A flatfile contains 200 records.I want to load first 50
records at first time running the job,second 50 records at
second time running and so on,how u can develop the job?pls
give the steps?pls pls
Answer Posted / sarath
i think using global parameter we can achieve this in transformer . first set the parameter value to 0 or 1 and finally after transforming set the parameter value to max(rownum) so that the value will b updated. for the next time using use that parameter as the starting point to load the data.
sorry if it is wrong.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the flow of loading data into fact & dimensional tables?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
If you want to use a same piece of code in different jobs, how will you achieve this?
Define oconv () and iconv () functions in datastage?
What is aggtorec restructure operator?
What is a folder? Difference types of stages?
Define repository tables in datastage?
What is the different type of jobs in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are the functionalities of link partitioner and link collector?
How many areas for files does datastage have?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How to convert RGB Value to Hexadecimal values in datastage?
What are stage variables?
How to RD using transformer?