Answer / riyaz

sed -n '3,100p' filename

Answer / subhash

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

Answer / manu

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

Answer / venugopal

Using sed command

Answer / sirisha

tail +2

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 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 in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

What are data elements?

0 Answers  

Describe stream connector?

0 Answers  

Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers  

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers  

A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?

1 Answers   TCS,

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

0 Answers   Wipro,

table actions available in oracle connector?

0 Answers   CTS,