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?
Answer Posted / srinu
flat file nothing but take sequence file use sed -n '1,50p'
using this command in filter option in the first running job.
second running job we use sed -n '51p,100' using this command
in this way we use other two times running job.....
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How do you schedule or monitoring the job?
How rejected rows are managed in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is ds designer?
project Steps,hits, Project level HArd things,Solved methods?
What is the flow of loading data into fact & dimensional tables?
What all the types of jobs you developed?
What are the steps required to kill the job in Datastage?
What is the difference between account and directory options ?
Name the third party tools that can be used in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
in oracle target stage when we use load option and when we use upsert option?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?