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.
1 4865How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
1 4502if 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
2 5624I have a few records all are same structures data, I want to store data in multiple targets how?
4 7126
How to convert RGB Value to Hexadecimal values in datastage?
Difference between data warehousing and olap?
what is the use of surogate key in datastage
Terminate Activity
Distinguish between informatica & datastage. Which one would you choose and why?
What is the command line function to import and export the ds jobs?
What is the use of hoursfromtime() function in transformer stage in datastage?
Explain datastage architecture?
How complex jobs are implemented in datstage to improve performance?
What are the types of hashed files in data stage
What are the features of datastage flow designer?
Define APT_CONFIG in Datastage?
What is merge stage?
What are the steps needed to create a simple basic datastage job?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)