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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between datastage and informatica?

594


Demonstrate experience in maintaining quality process standards?

1964


Nls stands for what in datastage?

750


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1814


How do you schedule or monitoring the job?

691






Describe routines in datastage? Enlist various types of routines.

601


What are the areas of application?

687


table actions available in oracle connector?

1113


Define oconv () and iconv () functions in datastage?

909


How can you write parallel routines in datastage PX?

637


Explain the importance of surrogate key in data warehousing?

732


Can you explain tagbatch restructure operator?

717


what is use of SDR function?

4726


Is the value of staging variable stored temporarily or permanently?

593


How do you run datastage job from the command line?

623