1)How to do error handling in datastage?
2)Did sequential stage accepts .xl files ,xml? znd how?
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 is the exact difference between dataset and fileset in datastage?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
What is the differentiate between data file and descriptor file?
how to get the unique records on multiple columns by using sequential file stage only
Hi This is Vijay, How can your remove the duplicates in sequential File?
15 Answers HCL, Scope International,
what is the use of invokation id
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
What are the components of ascential data stage?
What are the enhancements made in datastage 7.5 compare with 7.0?
How do you remove duplicate values in datastage?