What is the Use of Terminator Activity in Datastage server Jobs?
Latest Answer: A terminator stage can be used in a job sequence to ensure that the sequence is stopped cleanly if certain situations arise. You can have multiple terminator activities and can place them anywhere in the sequence. They are connected to other stages by ...
How we can increase the speed of job in datastage?
Latest Answer: To improve DS job performence we can fallow sertain techniques If it is PX job we can use pipeline or data partition techniques to run single job into multiple instance based on server configuration to gain good performence in DS.--->You can eliminate ...
What for exactly fileset is used?
I am new to data stage, so I am a bit confused when to use ODBC and when OCI.Added to it I saw the question where it was asked how to remove duplicate records in the target and many of them answered that
Latest Answer: The difference b/w ODBC and OCI is, odbc supports to read or write any kind of relational DB but OCI supports only oracle DB.For suppose if you want read a oracle table in DS in that case if you use odbc it wont give you good performance but oci will ...
how we import xml files into source stage?
Latest Answer: In source file we write sql queryselect distinct(sal) from customer_tab where Loc = 'Hyderabad',and rcp should be enable ...
Latest Answer: Yes,You can pass the parameters.There is a options called "Usage Variables" in job sequence.Here you can declare ur parameters.These will be available in entire job sequence. ...
Latest Answer: hi,first check in the director's log about the job condition.if you cannot find the errorgo to the input to output datatye conversions.or elsecheck the configiration file APT_CONFIG_FILE ...
How to call a Stored procedure which is in SQL Server database in Datastage job?
Latest Answer: You can use strored procedure stage in DS to call the any stored procedures from any Database type.Regards,Veeru. ...
What is the difference between Filter and External Filter stages?
Latest Answer: Filter is used to pass the records basing on some condition.We will have multiple where conditions to specify.We can send to different output linksExternal filter is used to execute commands of unix.You can give the commands in the specified box with ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
