Interested to Buy Any Domain ? << Click Here >> for more details...
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
- 2 Answers
- 26063 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / maruthi
IN MANY PLACES IN DATA STAGE YOU CAN USE UNIX COMMNDS.
Eg.)1.)IN SEQUENTIAL FILES CHECK FILE USES UNIX
COMMANDS,LATER U CAN GIVE UNIX COMMANDS AS FILTER,AND SO
MANY IN SEQ FILE SIDE TO FILENAME.
2.)IN BEFORE/AFTER SUBROUTINES U CAN SELECT EXEC SHELL
COMMAND AND U CAN GIVE UNIX COMMANDS TO CREATE FILES/DELETE
FILES.
SO MANY EG ,GO THROUGH THE HELP FILE.
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
How to read multiple files using a single datastage job if files have the same metadata?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Why do you need stage variables?
Name the third party tools that can be used in datastage?
How do u convert the columns to rows in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
options available in sequence job to run,validate?
What is merge stage?
How to RD using transformer?
How to find value from a column in a dataset?
Define data aggregation?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the use of hoursfromtime() function in transformer stage in datastage?
How complex jobs are implemented in datstage to improve performance?
