i want job aborted after some records are loaded into output
by using only sequential stage and dataset
Answer / guest
HI Friend,
Use constraint in transformer stage by selecting abort after
rows column and mention the no.of rows to be rpocessed, then
after those many rows job will abort.
Thanks,
Hanumantha Rao.
| Is This Answer Correct ? | 0 Yes | 1 No |
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
In Datastage, how you can fix the truncated data error?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
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
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?