DataStage can accept more than one delimiter. How to import data if it contains more than one delimiter?
Latest Answer: DS supports more than one delimiter, if file has more then one delimiter. to read multiple delimeters from flat file, define flat file type as fixed width.Suppose your flat file has data belowcust_no,name|phno100,x|10000200,y,20000if you specify flat ...
What is a routine? How can we use it in datastage?
Latest Answer: Routines are used to implement specific funtionlaty which will support DS jobs. routines are clasified into 2 types 1. Builtin 2. UserdefinedBuiltin: These routines are predefined and comes with DS softwareUserdefined: These are write user to implete ...
How to retrieve hash file data from administrator command?
What is data stage parallel extender?
Latest Answer: DataStage jobs are classified into 3 types1.Server job2.Parallel job3.Mainframe job3 types are designed for to do the ETL process. difference among them isServer job: execures sequentiall like row by row execution. as per performence wice it takes more ...
How to get outer join facility from Datastage Server?
How to pass input parameters using UNIX Shell script to DataStage Director?
Expalin difference between Data Sets and File Sets? where each one is used and how they are used?What is the size limit?
Latest Answer: The dataset and fileset both are file stage. Dataset can have single input link or single output link whereas, Fileset can have single input link or single output link and a single reject link.File set can executes only in parallel mode whereas,dataset ...
How to extract data from source to staging area using datastage parallel extender?
What is the order of execution in the transformer?
Latest Answer: Transformer execution order is Constraints, Stagevaribles then derivations. Pls correct me if this answer is wrong.Regards,Veera. ...
How to clear logs after 5 days, by using a routine?
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
