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!

Recent content by sam93

  1. sam93

    Connection parameter issue

    Hi, I am facing this problem in multiple sessions. I am using connection parameters defined in the parameter file to connect to different databases for lookups, and they used to work fine. For the last few days, I am facing a strange problem. If I make a change in the session (not related to...
  2. sam93

    Joining 2 tables with priority

    Thanks SM. The 1st query had a typo. SELECT DECODE(A.CD,NULL,B.CD,A.CD) CD, DECODE(A.CD,NULL,B.NAME,A.NAME) NAME FROM A FULL OUTER JOIN B ON A.CD = B.CD; would have worked. The 2nd one is definitely wrong. Any way, your answer addresses what I was looking for. Thanks for your help.
  3. sam93

    Joining 2 tables with priority

    Hi, I have to join data from 2 tables, say A and B, so that data from A takes priority over B. e.g. A has data CD NAME 1 a 2 b and B has CD NAME 2 bb 3 cc The result should be: 1 a 2 b 3 cc I am doing it as follows: SELECT DECODE(A.CD,NULL,B.CD,A.CD) CD...
  4. sam93

    Getting target DB timestamp

    Thanks Ties. Do you mean something like UPDATE <target> SET EFFECTIVE_FROM = SYSDATE .....?
  5. sam93

    Getting target DB timestamp

    Hi, I have a simple requirement. I am not sure what's the best way to do it. I have type 2 dimensions in my target DB (Oracle) with EFFECTIVE_FROM and EFFECTIVE_TO date columns. We want to poplulate these with database server system date and not the Informatica server system date. What is the...
  6. sam93

    Executing a session multiple times with different parameter values

    Hi, I have a requirement where I need to execute a session 8 times, once for each client. For every client, a separate source file is used. All the 8 source files have same structure but ofcoarse data related to 1 particular client. However, these source files are only created one at a time...
  7. sam93

    Pre-process to check record count in source

    Hi, I have an ETL process that will be executed daily. The requirement is to make sure that data has been loaded in the source for this process for the previous day (in this case, a table in the staging area), before kicking off this ETL process. I plan to do this by doing a record count in...
  8. sam93

    Import from Database disabled in Source Analyzer

    Thanks. I tried to check the privileges in the repository manager but I don't have privileges to edit the folder. Can you point out any significant drawbacks in terms of migration?
  9. sam93

    Import from Database disabled in Source Analyzer

    Hi, I have a shared folder. When I want to create a source in it, the Import from Database and Import from File options are disabled. These options are enabled in non-shared folders. Is there a restriction on shared folders in terms of importing source and targets? Thanks.
  10. sam93

    Using associated port with dynamic lookup

    Hi, I am having problem in using dynamic lookup. Here's my scenario: My source has the following columns: client_code, client_name, and expiry_date. A value in the expiry date column means that the record is not active after the given date. My target has the following columns: client_code...
  11. sam93

    Manual Commit

    Hi, I want to change the default behavior of auto committing any changes made in a record as soon as I leave it and want to commit changes made in multiple records on the click of a button. 1. How do I disable default committing? 2. How can I save changes in multiple records explicitly? Thanks.
  12. sam93

    Query parameter for combo box from another combo

    Hi, I have a combo box (say cmbB) in a form that needs to get populated through a parameterized query. The query parameter comes from another combo box (say cmbA). I have included a WHERE clause in my query to get value from the combo box (cmbA). But when I change my selection in the first...
  13. sam93

    Optimizing query with temp table

    Hi, I'm having problem tuning a query with 4 tables, one of which is a global temp. table. I created a normal table with the same structure and data as the temp table and used it in the query instead of the temp table and the query returned the data instantly. In the explain plan, if I use...
  14. sam93

    Using array values in SQL

    Hi, I want to pass an array of values (say product #s) from Java front end. The number of values in the array is not fixed. I can receive these values in my Oracle backend through a table type used as parameter in a procedure. The question is how can I then use these values in a SQL query. I...
  15. sam93

    Materialized view log for selected rows

    Hi, I cannot make any changes to the source table, including creating an index. I think I'll have to filter it in the mat. view with the WHERE clause. Thanks for your help.
See more

Part and Inventory Search

Back
Top