Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sdmy
  • Order by date
  1. sdmy

    MCE Exams

    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.
  2. sdmy

    Incremental load

    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...
  3. sdmy

    Comparison of tables

    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...
  4. sdmy

    Unix script for comparing text files???

    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...
  5. sdmy

    Comparison of tables

    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
  6. sdmy

    Comparison of tables

    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...
  7. sdmy

    Comparison of tables

    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...
  8. sdmy

    Comparison of tables

    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
  9. sdmy

    Comparison of tables

    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...
  10. sdmy

    Comparison of tables

    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...
  11. sdmy

    Comparison of tables

    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...
  12. sdmy

    Comparison of tables

    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)...

Part and Inventory Search

Back
Top