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

GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 101 of 119    Print  
dataset stage/lookup file stage/file stage
when do one use dataset stage/lookup file stage/file stage in a parallel job?or in other way what is the significance of these files...wat are their differences?


  
Total Answers and Comments: 1 Last Update: February 28, 2008     Asked by: chackozach 
  
 Sponsored Links



 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 28, 2008 00:44:32   #1  
nagoosk Member Since: November 2007   Contribution: 14    

RE: dataset stage/lookup file stage/file stage
DataSetFile: DataStage PX jobs uses the dataset file to organize the data.Dataset files preserves partitioning means u need not to partition the data when ever u read the data.It maintaines the persistent form.These are the operating system files.we can't read directly content of the file.Not in human readable form.There will be a control file whcih contains the path of the actual individual file.(extension .ds).
FileSet:A file set is collection of individual files distributed over the partitions.This is helpfull because some opeating systems impose the file size to 2 GB.This also preserves partitioning as dataset but it carrys formatting information of the data.It is in human readable form.
Lookup:Lookup stage is used to look up for other stage and as referene for database

 
Is this answer useful? Yes | No

 Related Questions

Hi ,in my pc i am unable to login to the Ascential datastage 7.1. whatever the hostname i am specifying... i m getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)n when i explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It\'s important that the lastline (host=name) is terminated
Read Answers (6) | Asked by : Madhavi

Hi ,in my pc i am unable to login to the Ascential datastage 7.1. whatever the hostname i am specifying... i m getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)n when i explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It\'s important that the lastline (host=name) is terminated

We have the Datastage server7.5 installed on Unix machine. We need to have a DSN to connect to the database which is on some other unix machine.please let me know it is enough if we create a DSN at the client machine or do we have to change the config file in UNIX?It is very urgent for us and we are not able to solve?pls help me in this regard.Madhavi
Read Answers (1) | Asked by : Madhavi

Can a sequential file stage can read the path from other sequential file. in which the data is stored

Latest Answer : what type of error dud you got.explain error. ...
Read Answers (1) | Asked by : mallikharjuna reddy

I am trying to execute batch file which has dsjob command to run data stage job from CLI.I am getting error code = 81011 (project not found but project is there)But I can run other jobs. I am getting into problem for one particular batch.any help
View Question | Asked by : Dilip

I am new to DataStage can we need to load a excel file which has both ARABIC and ENGLISH text. Here my source id IBM DB2. If I want to display the Arabic content in my browser I need to store it in the UNICODE format in the Database. Can any one tell how to store the content in a excel file as UNICODE NLS . In DataStage the option has been provided only for Sequential files.Thanks in advance.Regards,Kris.

How can I identify the duplicate rows in a seq or comma delimited file?the case is...> the source has 4 values like, agent id, agent name, etc... our requirement is that the ID shouldn't be repeated. so how can i identify the duplicate rows , set a flag and send the rejects to the specified reject file? the source systems data is directly given to us. tha's why we are getting these duplicates.if it has a primary key set up already then it would have been very easy.thanks in advance.
Read Answers (2) | Asked by : DS beginer

Latest Answer : You can use excel file as input by importing the .xls file.step1 --> Go to Administrative Tools -> Data Source (ODBC) --> System DSN. Click on Add button and configure the corresponding .xsl file in your system DSN. Make sure that workbook contains ...
Read Answers (2) | Asked by : Sowmya

While using oracle database as target or Source why we will use OCI stage why don't we use ODBC stage?
Read Answers (4) | Asked by : jaggu


 Sponsored Links



 
Related Articles

ODP.NET - Presenting Master-Detail Information Using a Dataset

ODP NET Presenting Master Detail Information Using a Dataset As mentioned before a DataSet object can have its own relations between data tables existing in it We can add these relations dynamically at the client side within an application to represent master detail or hierarchical information The f
 

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

What is Data File

In a logical data model, the conceptual data model which is based on the business semantic is being defined. Thus, entities and relationships and corresponding table and column design, object oriented classes, and XML tags, among other things are being laid regardless of the database will be physica
 

PHP Tutorials - File manipulation (Part-2)

File manipulation Part 2 In this PHP Tutorial you will learn the 2nd Part of File Manipulation Reading lines from a file Reading arbitrary amounts of data from a file Writing to a file Creating directories Removing a directory and Opening a directory for reading mosgoogle Reading lines from a file T
 

PHP Tutorials – File manipulation (Part 1)

PHP Tutorials File manipulation Part 1 In the PHP Tutorial You will learn about File manipulation Part 1 Checking file existence A file or directory Determining file size Creating and deleting files and Opening a file for writing reading or appending mosgoogle Checking file existence You can test
 

C Programming - File management in C

C Programming File management in C In this tutorial you will learn about C Programming File management in C File operation functions in C Defining and opening a file Closing a file The getw and putw functions The fprintf fscanf functions Random access to files and fseek function mosgoogle C suppor
 

The File Types Editor

The File Types Editor The File Types Editor can be used to create the required registry to establish a file association for the application being installed A file association is simply a link between a particular file extension and a particular application For example the file extension xls is norma
 

Working with File System in .NET

In this tutorial you will learn about Access and Manipulate Data Working with Disk Files Browsing for Files Streams and Backing Stores Using the FileStream Class Using the StreamReader and StreamWriter Classes Using the BinaryReader and BinaryWriter Classes Access and Manipulate Data Working with Di
 

Live DataStage Interview Questions

Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated questions here Live DataStage Interview Questions Published by Manoj G on 05 24 2005 Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated que
 

Oracle Apps 11i : File System

An Oracle Applications Release 11i system utilizes components from many Oracle products These product files are stored below a number of key top level directories on the database and application server machines Depending on how you chose to install Applications these product directories may be locat
 

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