Answer / vamsi

take source --->trf---->trg
in transformer constaints put inrownum <=10
then u can get the required answer.........

Answer / rajesh

Hi This is Rajesh...By using Tail also we can get last 10 records

Answer / alok

At source stage properties (I'm assuming Sequential File Stage is used), go to the Filter option in properties tab and type head -10. The sq file stage will read only top 10 records and ignore the rest.

Answer / radha guntupalli

If you want top ten records In seq file_options_filter-
head -10.For last 10 records tail -10.

Answer / snehasis

By using read first rows option in sequential file stage we can get 10 records out of 100 records of a file

Answer / chandu

while running prompt put 10 rows.

then the job terminates after 10rows in target

How many number of reject links merge stage can have?

7 Answers   TCS,

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,

What are the primary usages of datastage tool?

0 Answers  

what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

what is materialized view used datastage?

1 Answers   HSBC,

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

How many types of hash files are there?

0 Answers