03 January 2021

#IBM_Datastage

IBM DataStage
What is Data Stage?
What is Merge?
What is Routines and their types?
What is Job control?
What is APT_CONFIG in Datastage?
What is Repository tables in Datastage?
What is OConv () and IConv () functions in Datastage?
What is Project in Datastage?
What is Meta Stage?
What is Orabulk and BCP stages?
What is DS Designer?
What is the difference between Datastage 7.5 and 7.0?
What is the method of removing duplicates, without the remove duplicate stage?
What steps should be taken to improve Datastage jobs?
What are the steps required to kill the job in Datastage?
What is size of a transaction and an array means in a Datastage?
What is Quality stage?
Name the command line functions to import and export the DS jobs?
Name the different types of Lookups in Datastage?
Name the third party tools that can be used in Datastage?
Explain how a source file is populated?
Explain Usage Analysis in Datastage?
Why do we use exception activity in Datastage?
Why we use surrogate key?
Why do we use Link Partitioner and Link Collector in Datastage?
How can you write parallel routines in datastage PX?
How to manage date conversion in Datastage?
How a server job can be converted to a parallel job?
How do you find the number of rows in a sequential file?
How to clean the Datastage repository?
How a routine is called in Datastage job?
How can one find bugs in job sequence?
How complex jobs are implemented in Datstage to improve performance?
How many types of hash files are there?
How many types of views are there in a Datastage Director?
How rejected rows are managed in Datastage?
In Datastage, how you can fix the truncated data error?
Can you explain how could anyone drop the index before loading the data in target in Datastage?
Differentiate between data file and descriptor file?
Differentiate between datastage and informatica?
Differentiate between Join, Merge and Lookup stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Differentiate between validated and Compiled in the Datastage?
Differentiate between Hash file and Sequential file?
Differentiate between Operational Datastage (ODS) and Data warehouse?
Differentiate between Datastage and Datastage TX?
Differentiate between ODBC and DRS stage?
Does Datastage support slowly changing dimensions ?
Have you have ever worked in UNIX environment and why it is useful in Datastage?
NLS stands for what in Datastage?

No comments:

Post a Comment

Most views on this month