if ename='subbu' while running job the job should be abort
how come?
Answers were Sorted based on User's Feedback
Answer / rajesh
if inputlink.value='subbu' then call the function
DSLogFatal, which logs a fatal error and aborts the job.
Is This Answer Correct ? | 2 Yes | 0 No |
Use the transformer stage to abort this job when empname is subbu
Thanks
www.datagenx.net
Is This Answer Correct ? | 1 Yes | 0 No |
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
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Pls tell me what is troubleshooting in datastage view?
what is combinability and non combinability?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
how to cleansing data
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
how to unlock a locked job in datastage 8.0
how can find maximum salary by using Remove duplicate stage?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
Define data aggregation?