ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
   
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Stage
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
 Question Submitted By :: Me
I also faced this Question!!     Rank Answer Posted By  
 
  Re: WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
Answer
# 1
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 ?    15 Yes 3 No
Maruthi
 
  Re: WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
Answer
# 2
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 ?    21 Yes 3 No
Suresh R Angadi
 
 
 

 
 
 
Other Data Stage Interview Questions
 
  Question Asked @ Answers
 
which memory is used by lookup and join IBM4
why we use hash file for lookup?  5
How to generate surrogate key without using surrogate key stage? IBM4
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?  2
what is mapping lookup  1
can explain wt is the pool for file. CTS1
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow? IBM1
In merge stage can we update the values? TCS3
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job. Syntel4
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem. IBM1
what is factless fact table? IBM3
Hi This is Vijay How Can u Read the data from sequential file Parall'y? Semantic-Space5
 
For more Data Stage Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com