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 Rhinorhino 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: sam93
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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.
  7. 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...
  8. 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.
  9. 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...
  10. 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...
  11. 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...
  12. sam93

    Materialized view log for selected rows

    Hi, Is it possible to create a materialized view log on a table for some rows only. I have a huge table (about 25 mil. rows) with STATUS column. About 5% of the rows have a TYPE_CODE of '04'. Is it possible to create mat. view log only to track changes in those rows. If this is not possible...
  13. sam93

    Problem creating materialized view with primary key

    Hi, I'm having problem creating a materialized view with primary key. Here's my situation: I've got a mat. view (say M1) created on 3 underlying tables using REFRESH FAST ON DEMAND. The MAT. VIEW LOGs on the 3 tables are built using WITH ROWID option. I'm trying to build another mat. view (say...
  14. sam93

    Script for materialized log

    Hi, How can I see the script that was used to create a materialized view log. I need to find out what options were used while creating the log. Thanks.
  15. sam93

    REFRESH FORCE option in materialized views

    Hi, Can someone please tell if REFRESH FORCE option is fast refreshable? If yes then what is the syntax for this? Thanks.
  16. sam93

    Optimize analytical functions

    Hi, Are there any hints or methods specific to optimizing analytical functions in 9i? I've got a query that runs in miliseconds, but when I add an analytical function (FIRST_VALUE ..... OVER (PARTITION BY ..... ORDER BY ...), the it starts taking more than 10 minutes. The execution plan shows a...
  17. sam93

    Deleting target rows with multiple keys

    Hi, I have a question regarding deletion of rows from a relational target. I want to mark the source rows as 'Delete' and check the 'Delete' option for the target, so that if a source row already exists in the target table, it should be deleted. Firstly, I need to have a PK constraint defined...
  18. sam93

    Executing multiple commands

    Hi, I have to execute a couple of commands if a certain condition is true. e.g. If the incoming value is -ve then set value of a mapping variable as well as reject the record with an error. It would be something like this: IIF(in_port_value < 0, (SETVARIABLE($$v_map_var_counter) AND...
  19. sam93

    Reusable transformations usage

    Hi, What's the difference a between a reusable transformation and a non-reusable transformations that is created in a shared folder. I can create a short cut to the non-reusable transformation in the shared folder and use it. Then why do we need to create reusable transformations. Thanks.
  20. sam93

    Retrieving $PMRootDir value

    Hi, Can someone tell me where does Informatica keep information such as $PMRootDir in the repository? I can set it up from the Workflow Manager, but if I want to get this information without going to the Workflow Manager, where can I get it? Thanks!

Part and Inventory Search

Back
Top