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 / subhash
other than VARUN solution
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.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Describe the architecture of datastage?
How do you register plug-ins?
How do you remove duplicate values in datastage?
What is the different type of jobs in datastage?
How to read the length of word in unix?
Name the command line functions to import and export the DS jobs?
Why do we use link partitioner and link collector in datastage?
What are the primary usages of datastage tool?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is job control?
Lookup constraints
What is a folder? Difference types of stages?
What are stage variables, derivations and constants?
How can we improve the performance in datastage?