true

Learn Datastage from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Datastage: Delete Header And Footer On The Source Sequential File

Kriti C.

31/08/2017 1 0

Using unix commands:

For header sed: n '1p'

And footer sed: n '$p'

Use the 'Filter' option in the Sequential File stage and define the below filter commands:

To remove only header: sed'1d'

To remove header and footer: sed '1d:$d'

1 Like 0 Dislike

Follow 2

Other Lessons for You

To become a software engineer.

It requires a burning desire to become a software engineer by choosing a platform ( Eg: Data Warehousing, DBA,.Net, Java, etc.). Attend the primary skillset and secondary skillset courses without fail. Should...

Venkata Ramana

0 0

Will Big Data clean up ETL

The fuss in the Datawarehousing world is will Big Data kill the existing ETL tools. The answer is a big "NO". Big Data with the combination of ETL will pave the way for easy reporting and data maintenance....

Sharad

0 0

Datastage: DB2 Indirect Privileges For Stored Procedures

1. I recently updated a Datastage job to use a direct Update query instead of calling a Stored Procedure(SP) through the job which had the Update query.2. The result: The job failed with the error that...

Kriti C.

1 0

Datawarehouse: Bill Inmon Vs. Ralph Kimball

In the data warehousing field, we often hear about discussions on where a person / organization's philosophy falls into Bill Inmon's camp or into Ralph Kimball's camp. We describe below the difference...

Kriti C.

2 0

Data Modeling Training Video

Kriti C.

1 0

Find Datastage Training near you

Looking for Datastage Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for Datastage Classes?

The best tutors for Datastage Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Datastage with the Best Tutors

The best Tutors for Datastage Classes are on UrbanPro

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.

Datastage: Delete Header And Footer On The Source Sequential File

Using unix commands:

For header sed: n '1p'

And footer sed: n '$p'

Use the 'Filter' option in the Sequential File stage and define the below filter commands:To remove only header: sed'1d'To remove header and footer: sed '1d:$d'

Other Lessons for You

Looking for Datastage Training?

Looking for Datastage Classes?

Learn Datastage with the Best Tutors

Use the 'Filter' option in the Sequential File stage and define the below filter commands:

To remove only header: sed'1d'

To remove header and footer: sed '1d:$d'