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
how many rows sorted in sort stage by default in server jobs
What is a merge in datastage?
Differentiate between odbc and drs stage?
Define Merge?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Which algorithm you used for your hashfile?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Describe the main features of datastage?
What are constraints and derivations?
What are the types of views in datastage director?
why do u need the IOS upgradation in a FC switch
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How to manage date conversion in Datastage?
What are the stages in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2