 Related Questions a)Star Schema - Simple & Much Faster. Denormalized form. b)Snowflake Schema - Complex with more Granularity. More normalized form. Latest Answer : Is not star schema better performance wise (querying) as it has less no of join due to denormalized structure? Please clarify ... Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition Latest Answer : Hi:Primary key is the key we define on the table column or set of columns(composite pk) to make sure all the rows in a table are unique.Partition key is the key that we use while partition the table(in database), process the source records in ETL(in the ... Stage Variable - An intermediate processing variable that retains value during read and doesnt pass the value into target column. Derivation - Expression that specifies value to be passed on to the target Latest Answer : Stage variables: StageVariables are the buffes with in the transformer stage , wher you can braekup the complex calculations into simple, This can be used with that stage..an simple ex is if you wanna calculate b^2-4ac.. it can be defined ... Hashed File is classified broadly into 2 types. a) Static - Sub divided into 17 types based on Primary Key Pattern. b) Dynamic - sub divided into 2 types i) Generic ii) Latest Answer : Hashed File is classified broadly into 2 types. a) Static - Sub divided into 17 types based on Primary Key Pattern. b) Dynamic - sub divided into 2 types i) Generic ii) Specific. Default Hased file is "Dynamic ... 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. By using "ExcecSH" command at Before/After job properties. Latest Answer : You can specify the ExecDos Prompt in the after or before job routine. ... Config file consists of the following. a) Number of Processes or Nodes. b) Actual Disk Storage Location. Latest Answer : Biggest strength of Datastage PX is its configuration file.. Datastage engine learns about size and shape of the system by reading configuration file.It contains Nodes and resource available for running the job. ... In a Hashed File, the size of the file keeps changing randomly. If the size of the file increases it is called as "Modulus". If the size of the file decreases it is called as "Splitting". Latest Answer : Modulo is the calculated value which is calculated by using a Hash File Calculator. It tells the optimal number of groups to be created in the hash file to use it effectively. The Input to this Modulo calculation are the approximate number of records ... Latest Answer : XML files can be read using FOLDER stage followed by XML input stage in server jobs. ... Latest Answer : The question itself is a little ambiguous to me. I think the answer to the question might be, we will place some conditions like 'where' inside the OCI stage and the rejected rows can be obtained as shown in the example below:1) Say, there are ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
