Interested to Buy Any Domain ? << Click Here >> for more details...
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
- 2 Answers
- 25906 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh r angadi
you can call in the following places in ETL(DataStage)
1-Sequential File Stage (Stage->Stage Uses filter commands).
2-Before and after Stage Subroutines in Job Paramametrs tab.
3-Before and after Stage Subroutines in Transformer stage.
4-Job Sequences using Execute command Activity and Routine
activity.
5-Using DataStage Routines
6-Using Routines called ExecSH and ExecSHSilent
| Is This Answer Correct ? | 25 Yes | 3 No |
Answer / 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 |
What are the features of datastage flow designer?
what is the definitions for Datawarehose and Datamart?
What is orabulk stage?
What is the use of datastage director?
1)Source file contains one record, I want 100 records in target file.
Give an idea of system variables.
Name the third party tools that can be used in datastage?
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
what is snow flack schema?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
Which warehouse using in your datawarehouse
How do you register plug-ins?
Teradata 
