Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 33423 Views
- TCS, I also Faced
- E-Mail Answers
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
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how to add a new records into source?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Name the different types of Lookups in Datastage?
Where do you see different stages in the designer?
What are the types of containers and how to create them?
Describe link sort?
What is the differentiate between data file and descriptor file?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the steps needed to create a simple basic datastage job?
how do u catch bad rows from OCI stage? And what CLI stands for?
Explain Quality stage?
Why do we use exception activity in Datastage?
Can you filter data in hashed file?
