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 / 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
Why do we use exception activity in Datastage?
CHANGE CAPTURE
what is the difference between == and eq in UNIX shell scripting?
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 read the length of word in unix?
Define ds designer?
What is a ds designer?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How can we improve performance of data stage jobs?
What is the differentiate between data file and descriptor file?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How to clean the datastage repository?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How do you remove duplicate values in datastage?