Interested to Buy Any Domain ? << Click Here >> for more details...
A flat file 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 this job?
- 1 Answers
- 8340 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / subhash
1st Way:
1. Add 'row number' column in Seq File stage, so that each
record has a number associated with it.
2. Add a job param with which we can provide the number of
record from where we want to run the job. We can pass this
either using Sequence Start LOOP(List type variables-
50,100,150,200) or by shell script.
3. In the tfm, use a stage variable to run only from the
record number till 50 records by counting each record.
2nd way:
Design the job like this:
1. Add 'row number' column in Seq File stage, so that each
record has a number associated with it.
2. Use filter stage and write the conditions like this:
a. row number column<=50(in 1st link to load the records
in target file/database)
b. row number column>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 ? | 8 Yes | 1 No |
Post New Answer View All Answers
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
how to add a new records into source?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Differentiate between data file and descriptor file?
Highlight the main features of datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the important features of datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the types of views in datastage director?
How you can fix the truncated data error in datastage?
Define ds designer?
What are routines in datastage? Enlist various types of routines.
how to export or import the jobs in .ISX file
What is the difference between passive stage and active stage?
What is the difference between datastage and informatica?
