when we have to go for a sequential file stage & for a
dataset in datastage?
Answer / srinu
when the memory limit requirement is more then we go for
dataset.because sequential file does not support more than
2gb memory limit
| Is This Answer Correct ? | 2 Yes | 0 No |
What is difference between 8.1 , 8.5 and 9.1 ?
In one project how many shared containers are created?
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
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Explain entity, attribute and relationship in datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
what is the use of surogate key in datastage
how to capture rejected data by using join stage not for lookup stage. please let me know
Differentiate between validated and Compiled in the Datastage?