Interested to Buy Any Domain ? << Click Here >> for more details...
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
- 2 Answers
- 26175 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 |
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How to convert alpha Numeric values to alpha using functions?
1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?
6 Answers CTS, HCL, IBM, Wipro,
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
which r the connectors used in san?
Where do you see different stages in the designer?
How to read the length of word in unix?
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
What all are the different way to run a job?
What is difference between symmetric multiprocessing and massive parallel processing?
Teradata 
