The differerence between reference link and straight link is The straight link is the one where data are passed to next stage directly and the reference link is the one where it shows that it has a reference reference key to the main table For example in oracle EMP table has reference with DEPT table. If 2 source as file stage one is straight link and other is reference link to Hash file as reference and 1 transformer stage. If your job has more columns which are not defined in metadata if runtime propagation is enabled it will propagate those extra columns to the rest of the job Can both Source system Oracle, SQLServer…etc and Target Data warehouse may be oracle, SQLServer. ODBC: We can write both source query as well as lookup query in this stage itself We are not having the facility to write multiple queries in this stage. We are having the multi-row lookup facility in this stage.

Author:Togar Nagami
Language:English (Spanish)
Genre:Personal Growth
Published (Last):8 December 2005
PDF File Size:12.40 Mb
ePub File Size:5.71 Mb
Price:Free* [*Free Regsitration Required]

This means that only the owner has write permission. Update the permission of this etc directory located under.. To do this, change the permission to allow group write. We need to ensure whether the job is completely performing the task, what it is supposed to do.

It should fullfill all the business logic coded in the job. I cannot use the Range lookup since the values are not necessarily in a certain range. Do I have to create multiple datasets for each lookup? Or, are there any better options that I can avoid creating multiple datasets?

SQL Server source stage , Oracle target stage I like change capture to do a insert when there is a insert working update when there is a delete not working update when there is a update working Please let me know how I can achieve this. I have configuration files with 2 nodes. The source file is partitioned on custno. So , datawise there are 4 partitions but only 2 logical nodes.

As i understand 2 copies will be created. A In datastage Partioning and nodes is different concepts. The job can be partioned into seven types ,Nodes is reduce the time given for nodes Posted by.


DataStage Interview Questions And Answers

Data stage director is use for to run the jobs, validate the jobs, scheduling the jobs. Server components DS server: runs executable server jobs, under the control of the DS director, that extract, transform, and load data into a DWH. DS Package installer: A user interface used to install packaged DS jobs and plug-in; Repository or project: a central store that contains all the information required to build DWH or data mart. What r the stages u worked on?


DataStage Interview Questions

A 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. It is a program for Windows servers that extracts data from databases and change them into data warehouses. To import the DS jobs, dsimport. In Datastage 7. Merge means to join two or more tables. The two tables are joined on the basis of Primary key columns in both the tables.


Top DataStage Interview Questions and Answers

It is a tool that is used for working with large data warehouses and data marts for creating and maintaining a data repository. How is a DataStage source file filled? We can develop a SQL query or we can use a row generator extract tool through which we can fill the source file in DataStage. Subscribe to our youtube Channel.

Related Articles