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
Name the different sorting methods in datastage.
What is the different type of jobs in datastage?
Terminate Activity
What is aggtorec restructure operator?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the steps required to kill the job in Datastage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Have you have ever worked in unix environment and why it is useful in datastage?
What are the features of datastage flow designer?
Why do we use exception activity in Datastage?
What are stage variables, derivations and constants?
What are iconv and oconv?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Give an idea of system variables.
Differentiate between hash file and sequential file?