Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


source file contains 100 records, i want 10 records in
target file how it possible in datastage

Answers were Sorted based on User's Feedback



source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / vamsi

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

Is This Answer Correct ?    15 Yes 2 No

source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / rajesh

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

Is This Answer Correct ?    11 Yes 2 No

source file contains 100 records, i want 10 records in target file how it possible in datastage..

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.

Is This Answer Correct ?    11 Yes 4 No

source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / radha guntupalli

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

Is This Answer Correct ?    6 Yes 2 No

source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / snehasis

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

Is This Answer Correct ?    3 Yes 0 No

source file contains 100 records, i want 10 records in target file how it possible in datastage..

Answer / chandu

while running prompt put 10 rows.

then the job terminates after 10rows in target

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More Data Stage Interview Questions

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,


How do you register plug-ins?

0 Answers  


Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,


What is ds designer?

0 Answers  


What are the prerequisites for join stage

2 Answers  


WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

2 Answers   GE,


5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  


how to call sequential generator in datastage?

1 Answers   IBM,


how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,


we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,


guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers   TCS,


i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,


Categories