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
What are the differences between datastage and informatica?
Demonstrate experience in maintaining quality process standards?
Nls stands for what in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How do you schedule or monitoring the job?
Describe routines in datastage? Enlist various types of routines.
What are the areas of application?
table actions available in oracle connector?
Define oconv () and iconv () functions in datastage?
How can you write parallel routines in datastage PX?
Explain the importance of surrogate key in data warehousing?
Can you explain tagbatch restructure operator?
what is use of SDR function?
Is the value of staging variable stored temporarily or permanently?
How do you run datastage job from the command line?