Interested to Buy Any Domain ? << Click Here >> for more details...
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
- 4 Answers
- 15854 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shivam
For this we can use Head and tail stages from development
and debug stages. Suppose we have 10 records,And we are
asked to pick 2nd to 9th record in the output, then go for
the following:
Sequential file--->Head stage--->Tail stage---->Data set
In the Head stage properties mention the number of records
you want to extract 9 records, this way you will get 1st to
9th records(top 9) extracted. Now, in Tail stage properties
mention number of records to extract 8, this way you get
last 8 records out of top 9 i.e 2nd to 9th. Finally as an
output you will find records 1st and 10th dropped.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
Answer / prabhu
we use seq file
in that stage properties->options->filter in that SED'2,$!P' FILENMAE
IT ISWORKING
| Is This Answer Correct ? | 0 Yes | 2 No |
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
Display all files which have size more 3KB in given directory/folder.
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
Difference between JOIN,LOOKUP,MERGE?
how can or from where we can get reference data in scd type2 implementation?
Which commands are used to import and export the datastage jobs?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
What are stage variables?
source file contains 100 records, i want 10 records in target file how it possible in datastage
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
How to read the length of word in unix?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
Teradata 
