Latest Answer: How to load dimension table values and Fact table values?how to identify the dimension tables and fact tables? ...
Latest Answer: SAS DI studio is best when compared to Informatica and Datastage as it generates SAS code at the back end .SAS is highly flexible compared to other BI solution. ...
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: all r correct one only ...
Parallel Processing is broadly classified into 2 types. a) SMP - Symmetrical Multi Processing. b) MPP - Massive Parallel Processing.
Latest Answer: Hardware wise there are 3 types of parallel processing systems available:1. SMP (symetric multiprocessing: multiple CPUs, shared memory, single OS)2. MPP (Massively Parallel Processing Systems: multiple CPUs each having a personal set of resources - ...
How can u implement slowly changed dimensions in datastage? explain?2) can u join flat file and database in datastage?how?
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: surrogate key is nothing but a primary key,it gives a serial no. to all records.surrogate key is act's as a major role in type 2 scenario.if u have any updates to be applied on a database it will be directely effected on datawarehouse part(using surrogate ...
Latest Answer: MetaStage is a persistent metadata Directory that uniquely synchronizesmetadata across multiple separate silos, eliminating rekeying and the manualestablishment of cross-tool relationships. Based on patented technology, itprovides seamless cross-tool ...
Latest Answer: No, U cannot run parallel jobs in serverbut u can run parallel jobs AS server jobs, my changing APt_Config file and setting node = 1 or setting node map constrain with node1 ...
Latest Answer: Here in server we have to use some stages like link partitioner, link coll, inter process.. to implement ll'lism. And sometimes we have to use lot of stages to implement specific logic bcoz of few stages.. whereas in ll'll we have lot ...
Latest Answer: sql: delete from tablename a where rowid>(select min(rowid) from tablename b) where a'key values=b.key values.datastage server:using sort stage(option:allow duplicates(yes/no))or hash fileparallel: remove duplicate stageRegards,Madhava ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
