WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
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 |
Why do we use link partitioner and link collector in datastage?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
How a source file is populated?
Define Merge?
What is orabulk stage?
In merge stage can we update the values?
If the job aborted in a sequencer, how can we start that from the previews successful job.
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
client know skid info?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
Difference between in process and inter process?
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?