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
- 33440 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / varun
Design the job like this:
1. Read records from input flat file and click on option of
rownumbercolumn in the file. It will generate a unique
number corresponding to each record in that file.
2. Use filter stage and write the conditions like this:
a. rownumbercolumn<=50(in 1st link to load the records
in target file/database)
b. rownumbercolumn>50 (in 2nd link to load the records
in the file with the same name as input file name, in
overwrite mode)
So, first time when your job runs first 50 records will be
loaded in the target and same time the input file records
are overwritten with records next first 50 records i.e. 51
to 200.
2nd time when your job runs first 50 records(i.e. 51-100)
will be loaded in the target and same time the input file
records are overwritten with records next first 50 records
i.e. 101 to 200.
And so on, all 50-50 records will be loaded in each run to
the target
| Is This Answer Correct ? | 19 Yes | 9 No |
Post New Answer View All Answers
What are the different types of lookups in datastage?
Can you explain tagbatch restructure operator?
What are the main features of datastage?
What are the different type of jobs in datastage?
how can we create rank using datastage?what is the meaning of rank?
Explain entity, attribute and relationship in datastage?
What is quality stage?
What all are the different way to run a job?
Can you implement SCD2 using join, transformer and funnel stage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
whom do you report?
Differentiate between Join, Merge and Lookup stage?
What is the importance of the exception activity in datastage?
Can we use target hash file as a lookup ?
If you want to use the same piece of code in different jobs, how will you achieve it?
