Search results for query: *

Hi, I'm planning to write microstrategy certification (MCE) exam. What are all the books i have to read? sample questions? your exam experiences? and any other helpful pointers for exams. Thanks all.

Hi, we have a datamart in place which will be used by few downstream systems. We'll load the datamart once in a month and we are using datastage ETL tool to do that. Every month we will truncate the existing data after taking backup and load the Fresh data. We have decided to re-model the...

Thanks for your reply. I'm getting problems in the following part of the code: ----------------------------------------------------------- FILEHANDLER UTL_FILE.FILE_TYPE; L_DIR VARCHAR2(200):= 'c:/sample'; L_SQL_TEXT VARCHAR2(4000):=NULL; L_FINAL_STR...

Hi All, I need to compare two text files and print the ouput (differences) to an excel sheet. I need to do like this for around 500 files. I want to automate the process with unix script.Is there any unix script available to compare two text files and store the output in excel file. Please...

Hi, Thanks for your reply. The tool cannot be used if the database is huge and has lot of tables and the table has more columns and huge volume of data. The database that i'm having has all the above said properties... Any other ideas??? Thanks

Hi, Thanks for sending me the proc. I tried to use the same procedure to get the DDL's and i got struck with the following error. ORA-01756: quoted string not properly terminated set server output on; create or replace procedure myseq is CURSOR C1 IS SELECT table_name FROM USER_TABLES; Cursor...

1) The date columns are the same across all the 300 tables. Is there any way that i can exclude these columns and use the following query.. SELECT col1||','||col2||','||...||colx from ((SELECT <table_a> MINUS <table_b>) UNION (SELECT <table_b> MINUS <table_a>)); 2) Even if i exclude the...

Thanks. "If you don't want to code up each column, then write a "SQL-writing-SQL" script to access USER_TAB_COLUMNS and assemble the comparison scripts for you" Please suggest me how to do the above. Thanks

Thanks mufasa for your reply. The code works good. The real problem that i'm facing is, i have to compare the output for around 300 tables from both the databases and each table has an average of around 50 to 60 columns. Moreover, there are 4 to 7 columns with date field, which i need to skip...

I heard that using MINUS to find out the table differences is not reliable if you are comparing millions of records. If yes, is there any alternative way (Stored procedures/triggers) for doing the comparison. Also, i want the differences to be copied into excel or text file... Any help and...

Thanks for your reply and it's very helpful. Since the tables exists in a separate databases, i can create a dblink from one database and access the other by selecting the required columns and do the DBComparison. Does the query (usage of "minus") will run fast for the huge volume of data? Any...

Please let me know how can i compare two tables with same data in Oracle which has huge volume of data. My requirement is like this: I have two environment ..1)Oracle Source ---informatica ETL---Oracle target and 2) Oracle Source ---Datastage ETL---Oracle target. (OS is UNIX Solaris for both)...