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  >  Interview Questions  >  Data Warehousing  >  DataStage

 Print  |  
Question:  Suppose you have table "sample" & three columns in that table

sample:

Cola Colb Colc
1 10 100
2 20 200
3 30 300
Assume: cola is primary key
How will you fetch the record with maximum cola value using data stage tool into the target system



January 01, 2007 05:49:41 #1
    Member Since: Visitor    Total Comments: N/A 
RE: Suppose you have table "sample" & three columns i...
 

Hi

As per the question it is very clear that the source data is in Table

you can use oci stage to read the source file

in the oci Stage write user defined sql query as " Select Max(cola) from the table" which will fetch the maximum value available in the table then load the data to Target Table

Hope u got me

Thanks

Rk
     

 

Back To Question