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
- 33333 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
How to clean the datastage repository?
What is difference between join, merge and lookup stage?
what is the use of surogate key in datastage
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How to perform incremental load in datastage?
What is the difference between datastage and informatica?
Define data aggregation?
Terminate Activity
How you Implemented SCD Type 1 & Type 2 in your project?
What is the difference between informatica and datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is a datastage job?
EXPLAIN SCD
What are routines in datastage?
How many types of stage?
