Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
No Answer is Posted For this Question
Be the First to Post Answer
How do you load 10 different sources with 10 different layouts to 10 different tables?
I have a few records just I want to store each records tow times in target how?
how to run jon in unix back round process what is command use in runing a job?
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
What is the default padding character?
HOW CAN U DO ERROR HANDLING IN DATA STAGE?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
what is the best stage in datastage parller jobs to use full out join and why
I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 Answers Cognizant, IBM, TCS, Virtusa,
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers