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

What is the project in datastage?

0 Answers  

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

What is active and passive stage?

0 Answers  

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

What is the difference between validate and compile?

1 Answers   CTS,

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

why we use hash file for lookup?

5 Answers  

what about data stage requirement

1 Answers  

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

What is RCP?

2 Answers   TCS,