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
What is the flow of loading data into fact & dimensional tables?
What is difference between join, merge and lookup stage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are the different common services in datastage?
Name the different types of Lookups in Datastage?
Why fact table is in normal form?
Can you explain link buffering?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the various kinds of the hash file?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are the job parameters?
Define Job control?
Is the value of staging variable stored temporarily or permanently?
Where the datastage stored his repository?
Define meta stage?