GeekInterview.com
  I am new, Sign me up!
 

DataStage Interview Questions


DataStage Interview Questions

Questions: 390
Comments: 789
 DataStage Tags
 Showing Questions 41-50 of 390 Questions
<< Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
 Sponsored Links

 
 DataStage Interview Questions
Sorting Options :  

Have you ever contact with the DS Administration people?What are the situations and what problems you phased? 
Latest Answer: Creating projects, maintaining rights of users, killing hung jobs ...

How we will implement scd in DS?Explain with example ?Any scd ie scd1,scd2,scd3 . 
Latest Answer: If you are using Server version, you will have to use a combination of transformer, hashfiles for lookup and stage variables. If you are using the parallel version you will have touse the Change Capture and Change Apply stages ...

How can i load a flat file into target as fast as i can?Assuming that the source bottleneck is not there,that is there is no performance issues in the source side. 

in datastage job successfully finished. but showing errors in director window. How do we fix and find the cause for the errors  
Latest Answer: I think in designer u find the green colour but in Director -> log view --> u find some fatal errors and job is aborted, is it, Means job is successfully completed but the data is not loaded in to the target, may be some miss matched data, datatype ...

in how many ways we can delete dataset? If a record is duplicated 3 times then how to get middle duplicated record? Is it advisable to use basic Tfr in Parallel jobs? 
Latest Answer: w/o basic t/r also we can do this know, then y to use basic t/r here. ...

What are the different Debug stages available in Datastage PX? 
Latest Answer: head, tail, rowgenerator,columngenerator,peek,sample, write range map . ...

When you are able to handle Null handling and Data type changes in ODBC stages why you need Modify Stage? 
Latest Answer: by using this modify stage we can change data types,keep and drop columns and also we can handle null values ...

What is Pipeline Parallelism in Datastage? 
Latest Answer: It is the ability of a down streem stage to process arow ,which the up streem stage processed that row ...

Hi friends, i know while using lookup stage if the lookup table has huge amount of data we will go for sparse lookup or else will use normal lookup. would anybody explain how the memory will be allocated 
Latest Answer: "Hi friends, i know while using lookup stage if the lookup table has huge amount of data we will go for sparse lookup or else will use normal lookup. would anybody explain how the memory will be allocated for both type of lookups?" First ...

i am running huge amount of data through a sort stage and it is very slow. Is there any option which can increase the performance with in the sort stage? 
Latest Answer: See if it is orcle db then u can write user def query for sort and remove duplicates in the source itself. and maintaining some key partition teqniques u can improve the performence. If it is not the case means better go for some key partion teqniques ...

View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
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
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape