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...


I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

Answers were Sorted based on User's Feedback



I have a source like file it have Number of records and i want to load without first and last record..

Answer / shivam

For this we can use Head and tail stages from development
and debug stages. Suppose we have 10 records,And we are
asked to pick 2nd to 9th record in the output, then go for
the following:
Sequential file--->Head stage--->Tail stage---->Data set

In the Head stage properties mention the number of records
you want to extract 9 records, this way you will get 1st to
9th records(top 9) extracted. Now, in Tail stage properties
mention number of records to extract 8, this way you get
last 8 records out of top 9 i.e 2nd to 9th. Finally as an
output you will find records 1st and 10th dropped.

Is This Answer Correct ?    7 Yes 1 No

I have a source like file it have Number of records and i want to load without first and last record..

Answer / prasad

In seq file, we have filter option (datastage)

filter= sed '1d;$d'

In Unix= sed '1d;$d' File_Name

it will remove header and footer records(quotes must and should)

Is This Answer Correct ?    3 Yes 0 No

I have a source like file it have Number of records and i want to load without first and last record..

Answer / srinu

using external filter
in this we use command sed -n '1d,
$d'(this is unix command we use we get answer)
(or)
we use command tail +2 |sed -n '$d'

Is This Answer Correct ?    6 Yes 4 No

I have a source like file it have Number of records and i want to load without first and last record..

Answer / prabhu

we use seq file
in that stage properties->options->filter in that SED'2,$!P' FILENMAE
IT ISWORKING

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Data Stage Interview Questions

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  


Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,


A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,


Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,


how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,


Which commands are used to import and export the datastage jobs?

0 Answers  


country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,


What are stage variables?

0 Answers  


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

6 Answers   IBM,


i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,


How to read the length of word in unix?

0 Answers   CTS,


Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  


Categories