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?
- 3 Answers
- 8661 Views
- TCS, I also Faced
- E-Mail Answers
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 | 5 No |
Post New Answer View All Answers
Enlist various types of routines in datastage.
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What are the primary usages of datastage tool?
Define Job control?
What are the enhancements made in datastage 7.5 compare with 7.0?
How to clean the datastage repository?
Distinguish between informatica & datastage. Which one would you choose and why?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Is possible to create skid in dim,fact tables?
How many types of sorting methods are available in datastage?
Why fact table is in normal form?
Differentiate between datastage and informatica?
What is a ds designer?
what is the difference between == and eq in UNIX shell scripting?
what is 'reconsideration error' and how can i respond to this error and how to debug this
