How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
Answer Posted / sreenu
By using Unix Command Head , Tail
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How to clean the datastage repository?
What are the steps needed to create a simple basic datastage job?
Terminate Activity
What is oci?
Differentiate between Join, Merge and Lookup stage?
which r the connectors used in san?
Name the command line functions to import and export the DS jobs?
Notification Activity
Define data aggregation?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the functionalities of link collector?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How to reverse the string using unix?