what is the use of materialized view?
How many Key we can define in remove duplicate stage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How can one find bugs in job sequence?
How to clean the datastage repository?
How do you import and export the datastage jobs?
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 many types of sorting methods are available in datastage?
Differentiate between hash file and sequential file?
Differentiate between Join, Merge and Lookup stage?
Give an idea of system variables.
Highlight the main features of datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
