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 42 of 122    Print  
What for we use Hashed files in datastage job? Give an example

  
Total Answers and Comments: 2 Last Update: February 22, 2007     Asked by: Lakshmi Kumar 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 28, 2006 06:34:01   #1  
naveen patil        

RE: What for we use Hashed files in datastage job? Giv...
mainly hased files are used for lookup perpose. for example ur looking for the data whether the entry is their or not. if it is thr do something otherwise something else
 
Is this answer useful? Yes | No
February 22, 2007 21:24:18   #2  
noverino Member Since: December 2006   Contribution: 7    

RE: What for we use Hashed files in datastage job? Giv...
I'm agree with naveen patil, Hashed file is used for lookup process. Beside that, Hashed file can also be used if we want to get Distinct data from a source by using the column as key. Sample, I want to get list of country from Customer records. One possible solution is I create a Hashed file and using Country as its key. Then I can get distinct value of Country.

 
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

View Question | Asked by : Amar

Latest Answer : Parallel extender is that the parallel processing of data extraction and transformation application . there are two types of parallel processing 1) pipeline parallelism 2) partition parallelism. ...
Read Answers (2) | Asked by : Deepak Prasad

View Question | Asked by : saritha.ppr

If a DataStage job has aborted after say 1000 records, how to continue the load from 1000th record after fixing the error?
Read Answers (6) | Asked by : etl

Latest Answer : two links avilable in datastage 1.primary link 2. reference linkprimary link means:strightly forwarded standard line ________________reference link means:horizentling table------------------------------> ...

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.

We have to choose between Datastage and Informatica.Which of these is better?Our DW is approx. 3-5 GBEnvironment is NT.We have INFA 7.2 and the business we just took over has Datastage 7.5. Here's one side of the story:A customer that recently migrated from Ascential DataStage 7.5 to Informatica PowerCenter 7. The customer has identified that Informatica outperformed Ascential DataStage in the following areas.· Performance - Informatica PowerCenter 2.5x faster than DataStage
View Question | Asked by : Amar


 Sponsored Links

 
Related Articles

Importance of Header Files

What is the importance of header files? The main role of header file is it is used to share information among various files. In brief, if we have several functions say 4 functions named as f1, f2, f3, f4 placed in file say sample.c and if all the functions want to get accessed by each other then all
 

Top 10 Application Security Vulnerabilities in Web.config Files - Part One

These days, the biggest threat to an network security comes from its public Web site and the Web-based applications found there. Unlike internal-only network services such as databases-which can be sealed off from the outside via firewalls-a public Web site is generally accessible to anyone who wan
 

Top 10 Application Security Vulnerabilities in Web.config Files - Part Two

Some of the most common and dangerous application security vulnerabilities that exist in ASP.NET Web-based applications come not from the C# or VB.NET code that make up its pages and service methods, but instead from the XML code that makes up its Web.config files. Incorrect configurations can open
 

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
 





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