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 116 of 126    Print  
write query for removing duplicates in source stage?
how we import xml files into source stage?


  
Total Answers and Comments: 1 Last Update: June 24, 2008     Asked by: pavan.daddanalla 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 24, 2008 05:48:34   #1  
nagakalyan Member Since: June 2008   Contribution: 8    

RE: write query for removing duplicates in source stage?

In source file we write sql query
select distinct(sal) from customer_tab where Loc = 'Hyderabad',and rcp should be enable


 
Is this answer useful? Yes | No

 Related Questions

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

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 (3) | Asked by : DS beginer

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

Latest Answer : In the Filter option,u can use the UNIX command like this to filter the input records..head -3 input_file.dat ...
Read Answers (4) | Asked by : madycool

1.What is the use of parameters in datastage job?2.What is the difference between datastage 6 and datasttage 7.0?3.Whta is unit testing, system testing and integration testing?4.seheduling the jobs in Datastage?5.What is the difference between datastage 7.1 and datasttage 7.5?6.How to do error handling in datastage?7.how do you remove duplicates in a flatfile?
Read Answers (4) | Asked by : srinivas

Latest Answer : In Transformer Stage click on properities tab in tool bar(Left corner tab). It displays stage properities page like all the other job properities page. There you can specify your before after stage subroutins. ...
Read Answers (1) | Asked by : suganya

View Question | Asked by :

Latest Answer : A Filter stage  is used to filter the incoming data ,for suppose u want to get the details of customer 20 if u give customer 20 as the constraint in filter it will display only the customer 20 files and u can also give a reject link,the rest of the ...
Read Answers (1) | Asked by : infinity


 Sponsored Links

 
Related Articles

What is an Ad Hoc Query

An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools. This is in contrast to any query which
 

Structured Query Language (SQL) - Basic Concepts

Structured Query Language SQL Basic Concepts Having query about what a SQL is It is Structured Query language It is a non procedural language and it is a database language mosgoogle Categories in SQL commands There are 3 broad categories in SQL commands They are namely Data Definition language DDL
 

How To Write The Main Heading For Your Essay

How To Write The Main Heading For Your Essay When you write an essay you will want to make sure you write a good heading To write a good heading you will need to plan your essay very effectively If you remember any good points from lectures these could be things you may want to use to create a good
 

How To Write a Good Essay

How To Write a Good Essay While there are many different methods you can use to write an essay standard essays will follow specific formats Understanding the basic format of an essay will allow you to write informative articles which will capture the attention of those that read it mosgoogle The fir
 

How To Write A College Essay

How To Write A College Essay The best way to write a college essay is to start by brainstorming ideas You will also want to make a list of topics you re interested in While there are other ways you can write a college level essay this method is the easiest mosgoogle When you brainstorm you will want
 

How To Write A Killer Resume

How To Write A Killer Resume When you apply for a job it can be argued that your resume is the single most important factor to whether or not you will be hired It is not uncommon for people to spend days making sure they create the perfect resume mosgoogle Making even small mistakes on your resume c
 

Web 2.0 and The Read/Write Web

Web 2 0 and The Read Write Web One of the emerging themes of Web 2 0 is the ability for users to add data to web sites directly In Web 1 0 web content was managed by so called webmasters” The webmaster would update HTML web pages using simple text editors like Notepad or advanced web
 

ASP.NET 2.0 Training : Data Source Object Model

ASP NET 2 0 Training Data Source Object Model In this tutorial you will learn about Data Source Object Model in ASP NET 2 0 the Rationale of DataSource components Data Source Control Internals Tabular DataSource Controls Hierarchical Data Source Controls The SqlDataSource Control Usage and Data Sour
 

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
 

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