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 / venky
first u use sequence generator for the flat file,after that
we take rank transformation in that take top as 50 records
and run the session 4 times it gives 200 records.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Explain the situation where you have applied SCD in your project?
What is the method of removing duplicates, without the remove duplicate stage?
What are the important features of datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is staging variable?
Have you used Unstructured data?
What is the purpose of pivot stage and types of containers in datastage
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 a server job can be converted to a parallel job?
How do you reject records in a transformer?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Is it possible to query a hash file?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is data partitioning?