how to clear the source file?
2) diff b/t odbc & Oracle?what is node?
3) explain one complex job u face in ur project
Answers were Sorted based on User's Feedback
Answer / kiran
1)how to clear the source file?
Ana:by using 3rd Party tool u can clear the source
2) diff b/t odbc & Oracle?what is node?
Ans:Node: its used to split the data into its memory location
3) explain one complex job u face in ur project
| Is This Answer Correct ? | 0 Yes | 8 No |
What is process model?
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
job locking methods? How can we unlock the job?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Define APT_CONFIG in Datastage?
In merge stage can we update the values?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
source contains 2 columns comes to target 4 columns how
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
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?