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
project Steps,hits, Project level HArd things,Solved methods?
Define oconv () and iconv () functions in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Is the value of staging variable stored temporarily or permanently?
Can you implement SCD2 using join, transformer and funnel stage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How to reverse the string using SQL?
How and where you used hash file?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are routines in datastage? Enlist various types of routines.
CHANGE CAPTURE
To see hidden files in LINIX?
Explain the importance of surrogate key in data warehousing?
Can you explain tagbatch restructure operator?
EXPLAIN SCD