how technical design will be prepared in datastage?

k2_swarupa

 Profile Answers by k2_swarupa Questions by k2_swarupa

• Apr 16th, 2009

If you want to prepare a design doc, then you should know the complete flow of your project along with business rule. Technical design doc is nothing but the flow of the process, to describe in jobs.

Ramya_DS

 Profile Answers by Ramya_DS Questions by Ramya_DS

• Dec 16th, 2008

It varies from company to company

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

nirmal1in  

 Profile Answers by nirmal1in Questions by nirmal1in

• Member Since Jan-2010 | Jan 17th, 2010

---

This can be accomplished in following way:

Example: table - emp

For First n rows:

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename desc) a
FROM emp) x
WHERE x.a < 5 --- say n is 5 display first 5 records

For last n rows:

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename) a
FROM emp) x
WHERE x.a < 5

FROM )WHERE .a<

This query can be used for finding nth row also say n = 5

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename desc) a
FROM emp) x
WHERE x.a = 5

deepthi

• May 17th, 2012

Code
SELECT rownum,a.*FROM(SELECT rownum,b.*FROM emp b ORDER BY rownum DESC) a WHERE rownum <&n;

Vasavi Katakam

 Profile Answers by Vasavi Katakam Questions by Vasavi Katakam

• Jul 18th, 2011

For First N Rows:

Code

1.  
2. SELECT top 5 * FROM table_name
3.  

For Last N Rows:

Code

1.  
2. SELECT * FROM
3. (SELECT top 5 * FROM
4. table_name
5. ORDER BY Columnname DESC)
6. ORDER BY Columnname ASC
7.  

Improve Answer