Triggers,VIEW,Procedures
What are the components of datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to reverse the string using SQL?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can you explain repository tables in datastage?
How many Key we can define in remove duplicate stage?
How do you import and export the datastage jobs?
What are the different layers in the information server architecture?
Can you explain tagbatch restructure operator?
What are the enhancements made in datastage 7.5 compare with 7.0?
Which warehouse using in your datawarehouse
What are the steps needed to create a simple basic datastage job?
Explain connectivity between datastage with datasources?
What is a merge?