insequential file 2header avaliable,and 100 records
avaliable.how to skip the 2 headers and load 100 records
target?

Answers were Sorted based on User's Feedback



insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 1..

Answer / riyaz

sed -n '3,100p' filename

Is This Answer Correct ?    8 Yes 0 No

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 1..

Answer / subhash

sed -n '3,100p' filename
or
sed -n '1,2d' filename
Or
tail -98 filename

Is This Answer Correct ?    8 Yes 0 No

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 1..

Answer / manu

By using 'SED'command like this
for header sed -n '1|p’

Is This Answer Correct ?    3 Yes 0 No

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 1..

Answer / venugopal

Using sed command

Is This Answer Correct ?    2 Yes 0 No

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 1..

Answer / sirisha

tail +2

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Data Stage Interview Questions

What is the difference between informatica and datastage?

0 Answers  


1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  


Have you used Unstructured data?

0 Answers   CTS,


my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,


SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  


hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,


In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,


Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,


insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 Answers  


how to cleansing data

6 Answers   Cap Gemini,


what is a message handler

3 Answers   IBM,


Enlist various types of routines in datastage.

0 Answers  


Categories