how many rows sorted in sort stage by default in server jobs
With out using Funnel Stage, how to populate the data from different sources to single target
What are the types of views in datastage director?
What are the different types of lookups in datastage?
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
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
Can you explain tagbatch restructure operator?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
Explain datastage architecture?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
what is the use of DSattchJob?DetachJob? where can we find it?
How you Remove the Dataset in Unix?