GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 28 of 390    Print  
How do you populate source files?

  
Total Answers and Comments: 5 Last Update: December 29, 2008   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: sekr
 
there are many ways to populate one is writting SQL statment in oracle is one way

Above answer was rated as good by the following members:
ysuresh, ETLSafari
December 09, 2005 23:46:55   #1  
sekr Member Since: December 2005   Contribution: 42    

RE: How do you populate source files?
there are many ways to populate one is writting SQL statment in oracle is one way
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
May 18, 2006 11:21:01   #2  
sekr Member Since: December 2005   Contribution: 42    

RE: How do you populate source files?
how to popluate source through OCI and SQL Loader
 
Is this answer useful? Yes | No
May 06, 2007 22:42:59   #3  
hanug Member Since: June 2006   Contribution: 24    

RE: How do you populate source files?

It seems the question is not quite right.

Can you please explain what do you mean by populate "source files".

Hanu.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
October 23, 2008 04:27:10   #4  
ETLSafari Member Since: October 2008   Contribution: 2    

RE: How do you populate source files?
In DW concept the source file is the one provided by the user or OLTP system and is extracted by scripts feed in to ETL system for processing. So it is to be taken as input and to output/populate.
 
Is this answer useful? Yes | No
December 29, 2008 06:22:48   #5  
tisha24 Member Since: September 2008   Contribution: 10    

RE: How do you populate source files?
If this question means creating dummy records for parallel jobs then

1. need to load the proper metadata to the row generator stage
2. and then supply the criteria and conditions like how the data should look like. for ex if its numeric value we can specific like the range starting values end values and etc.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
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