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 / sreekanth reddy peddakkagari
Answer given by varun is exactly correct but there is a
small correction in the answer, as varun told that at the
same time we can not use same file name as the source as
well as target , so we need to read from actual file
(Ex:Source.txt) write it to new file(Ex:New_Source.txt),
after that we need to rename the new file to old file using
after Subroutene(mv New_Source.txt Source.txt).
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Name the third party tools that can be used in datastage?
What are the different plug-ins stages used in your projects?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Explain ibm infosphere information server and highlight its main features?
Can you explain tagbatch restructure operator?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the areas of application?
Difference between data warehousing and olap?
What is use Array size in datastage
how to sort two columns in single job in datastage.
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How to perform incremental load in datastage?
What is the difference between odbc and drs stage?
table actions available in oracle connector?
what is use of SDR function?