- Differences between datastage 7.5 and 8.5 pdf#
- Differences between datastage 7.5 and 8.5 generator#
- Differences between datastage 7.5 and 8.5 windows#
Last but not the least, we should understand and assess the available tuning knobs.ġ3) Differentiate between Join, Merge and Lookup stage?Īll the three concepts are different from each other in the way they use the memory storage, compare input requirements and how they treat various records. Also, we should not include RDBMS in start of testing phase. After that, we should distribute the file systems to remove bottlenecks, if any. Then we should isolate and solve the problems, one by one. Secondly, we should not use only one flow for performance testing.
In order to improve performance of Datastage jobs, we have to first establish the baselines. We can use the option, as allow duplicate = false.ġ2) What steps should be taken to improve Datastage jobs? Such routines are also created in DS manager and can be called from transformer stage.ġ1) What is the method of removing duplicates, without the remove duplicate stage?ĭuplicates can be removed by using Sort stage. We can write parallel routines in C or C++ compiler. There are three types of routines such as, parallel routines, main frame routines and server routines.ġ0) How can you write parallel routines in datastage PX? Routines are basically collection of functions that is defined by DS manager. Datastage is more user-friendly as compared to Informatica. Also, Informatica is more scalable than Datastage. While, there is no concept of partition and parallelism in informatica for node configuration. In datastage, there is a concept of partition, parallelism for node configuration. The two tables are joined on the basis of Primary key columns in both the tables.ħ) Differentiate between data file and descriptor file?Īs the name implies, data files contains the data and the descriptor file contains the description/information about the data in the data files.Ĩ) Differentiate between datastage and informatica? The truncated data error can be fixed by using ENVIRONMENT VARIABLE ‘ IMPORT_REJECT_STRING_FIELD_OVERRUN’. In Datastage 7.5 many new stages are added for more robustness and smooth performance, such as Procedure Stage, Command Stage, Generate Report etc.ĥ) In Datastage, how you can fix the truncated data error?
To import the DS jobs, dsimport.exe is used and to export the DS jobs, dsexport.exe is used.Ĥ) What is the difference between Datastage 7.5 and 7.0?
Differences between datastage 7.5 and 8.5 generator#
We can populate a source file in many ways such as by creating a SQL query in Oracle, or by using row generator extract tool etc.ģ) Name the command line functions to import and export the DS jobs? It has become an essential part of IBM WebSphere Data Integration suite.Ģ) Explain how a source file is populated?
Differences between datastage 7.5 and 8.5 windows#
It is a program for Windows servers that extracts data from databases and change them into data warehouses. If you want to become an expert in Datastage ,Register for Datastage online traininghere.Ī data stage is basically a tool that is used to design, develop and execute various applications to fill multiple tables in data warehouse or data marts. Our experts prepared these Datastage interview questions to accommodate freshers level to most experienced level technical interviews.
Differences between datastage 7.5 and 8.5 pdf#
Here is a list of Top most important Datastage interview questions and answers by Experts.If you want to download Datastage interview questions pdf free ,you can register with RVH techguru. Top most important Datastage interview questions and answers by Experts:
0 kommentar(er)
