How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Notification Activity
how to add a new records into source?
options available in sequence job to run,validate?
Explain the situation where you have applied SCD in your project?
On which Dimension Table you implemented SCD Type in your Project
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
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
what is the use of skid in reporting?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How to reverse the string using unix?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
what is repositery?
what are the errors,warnings in datastage
