I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
Explain about ur projets on teradata???
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
Under which circumstance should you create an index on a table?
What is a super key?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
Which three commands cause a transaction to end?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
How does non-cluster index functions?
What are the tools used for backup and ticketing?
What is the difference between oracle and MS Access?
What is the function of cluster index?
How concurrency problems effect the database?