Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9988 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 | 6 No |
Post New Answer View All Answers
Why do we use exception activity in Datastage?
Difference between sequential file and data set?
What is a merge?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Notification Activity
What are the types of jobs we have in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the types of containers in datastage?
How the ipc stage work?
What is the precedence of stage variables,derivations, and constraints?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Define repository tables in datastage?
What is the purpose of pivot stage and types of containers in datastage
What are iconv and oconv?
Describe stream connector?
