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 37 of 126    Print  
how to load the top 3 marks(column name) from seqential file to the target

  
Total Answers and Comments: 1 Last Update: February 20, 2007     Asked by: sudhakar 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 20, 2007 06:01:20   #1  
Sathish123 Member Since: February 2007   Contribution: 3    

RE: how to load the top 3 marks(column name) from seqe...
First sort the data on Marks  column using sort stage then use transformer stage.
In constraints use system variable @INROWNUM (@INROWNUM<=3).
In this way you can get top 3 marks.

 
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

Latest Answer : yes you can change the column name only for oracle 9.2 and above.RDBMS:   Relational DataBase Managment System ( for example a combination of object type into  nested table and  using this nestedtable as a datatype for a  ...
Tags : RDBMS

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

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


 Sponsored Links

 
Related Articles

jQuery - Column Highlighting

Learning jQuery Column Highlighting It can be a nice user interface enhancement to visually remind the user of what has been done in the past By highlighting the column that was most recently used for sorting we can focus the user s attention on the part of the table that is most likely to be releva
 

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
 

CSS3 Multi Column Feature

CSS3 Multi Column Feature CSS3 Multi Column Module is a vital feature present in CSS3 This feature enables users to flow the content of an element into multiple columns The CSS3 Multi Column Module is a important feature because it gives users the following features or advantages there is no need to
 

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
 

Load Testing Interview Questions

Load Testing Interview Questions This article provides Software Testing Interview Questions covering Load Testing questions For more Interview Questions Answers related to testing click on links provided at the end of each question set mosgoogle Load Testing 1 What are the uses of load testin
 

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
 

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