GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

DataStage Interview Questions


DataStage Interview Questions

Questions: 364
Comments: 674
 DataStage Tags
 Showing Questions 1-10 of 364 Questions
[1] 2 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 DataStage Interview Questions
Sorting Options :  

Latest Answer: How to load dimension table values and Fact table values?how to identify the dimension tables and fact tables? ...
Read Answers (10) | Asked by : Phantom

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. ...
Read Answers (9) | Asked by : anunath

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?
Read Answers (7) | Asked by : ramaiah

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 ...
Read Answers (6) | Asked by : mallikharjuna reddy

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 ...
Read Answers (6) | Asked by : prasanna

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 >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
Sponsored Links

 
Sponsored Links



 

 
 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape