Triggers,VIEW,Procedures
Differentiate between data file and descriptor file?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is a merge in datastage?
Explain the situation where you have applied SCD in your project?
How do you import and export the datastage jobs?
How complex jobs are implemented in datstage to improve performance?
What are stage variables?
What is the difference between informatica and datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is process model?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is the difference between server job and parallel jobs?
What are the different kinds of views available in a datastage director?