WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
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
Define Routines and their types?
What is "fatal error/rdbms code 3996" error?
What is the difference between passive stage and active stage?
Explain ibm infosphere information server and highlight its main features?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to implement complex jobs in data stage?
If you want to use the same piece of code in different jobs, how will you achieve it?
How many types of sorting methods are available in datastage?
Define data aggregation?
Define ds designer?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Have you used Unstructured data?
What is the process of killing a job in datastage?
What is quality stage?