What are transforms and what is the differenece between routines and transforms?
No Answer is Posted For this Question
Be the First to Post Answer
How many types of views are there in a datastage director?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
in oracle target stage when we use load option and when we use upsert option?
How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
How to perform incremental load in datastage?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
What are the various kinds of the hash file?
What are the partition techniques available in your last project?
What is the importance of the exception activity in datastage?
What is the different type of jobs in datastage?