1)How to do error handling in datastage?
2)Did sequential stage accepts .xl files ,xml? znd how?
- 2 Answers
- 13395 Views
- UHG, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bond
YOU CAN HANDLE EROOR BY SENDING NOTIFICATION MESSAGE.
FOR XML YOU NEED TO USE XML INPUT STAGE.
| Is This Answer Correct ? | 4 Yes | 4 No |
What are stage variables and constants?
Enlist various types of routines in datastage.
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
What steps should be taken to improve Datastage jobs?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
Can you define merge?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is a merge?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Teradata 
