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?
Answers were Sorted based on User's Feedback
Answer / 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 |
How to get max salary of an organization using data stage stages........... can any body help me plz.......
What is the use of surrogate key stage?
Name the different types of Lookups in Datastage?
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
What are the types of containers in datastage?
How do u view log file for a particular job?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
What are stage variables and constants?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
options available in sequence job to run,validate?
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
which unix commands mostly used in datastage