How can u write exception handling in seq file????
Answers were Sorted based on User's Feedback
Answer / nagaa
in sequential file set missing file mode to ok.by this we
can do exceptional handling in sequential file
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / venkatesh
we have the exceptio handler by using that one we cancall
| Is This Answer Correct ? | 1 Yes | 9 No |
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
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
how to closeing records after 10,000 records come?
Explain the scenarios where sequential file stage runs in parallel?
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
How to use Environment variable's in datastage?(use of process)
table actions available in oracle connector?