 Related Questions Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database. Latest Answer : Primary Key does not allow data duplications for actual source data. We cannot maintain historical data of each record using PK.SID acts as a primary key in target WH systems, that allows data duplications and maintains complete historical data along ... Data in a Database is a) Detailed or Transactional b) Both Readable and Writable. c) Current. Latest Answer : Database data is in the form of OLTP and Data warehouse data will be in the form of OLAP. OLTP is for transactional process and OLAP is for Analysis purpose. ... Orchestrate itself is an ETL tool with extensive parallel processing capabilities and running on UNIX platform. Datastage used Orchestrate with Datastage XE (Beta version of 6.0) to incorporate the parallel Using "dsjob" command as follows. dsjob -run -jobstatus projectname jobname Latest Answer : u can use dsjob executable command from unix or command line.The previous post was correct.Hanu. ... Default cache size is 256 MB. We can incraese it by going into Datastage Administrator and selecting the Tunable Tab and specify the cache size over there. Latest Answer : The default cache size is 128 MB. This is primarily used for hash file data cache in the server. This setting is only can be done in Administrator not in job level. Job level tuning is available only for Buffer Size. ... ODBC : a) Poor Performance. b) Can be used for Variety of Databases. c) Can handle Stored Procedures. Plug-In: a) Good Performance. b) Database specific.(Only one database) c) Cannot handle Stored Procedures. We use a) "Iconv" function - Internal Convertion. b) "Oconv" function - External Convertion. Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]") Latest Answer : we can achieve this conversion using transformer stage conversion functions in PX.Hanu. ... There are 3 types of views in Datastage Director a) Job View - Dates of Jobs Compiled. b) Log View - Status of Job last run c) Status View - Warning Messages, Event Messages, Program Generated Messages. Latest Answer : From what I know there are four views1> Status 2> Schedule3> Log4> Detail. ... What are the difficulties faced in using DataStage ? or what are the constraints in using DataStage ? Latest Answer : U can call external functions, subroutines by using Before/After stage/job Subroutines : ExecSHExecDOSor By using Command Stage Plug-In or by calling the routine from external command activity from Job Sequence. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
