Search results for query: *

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

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

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

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

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

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.

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

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.

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

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

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

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

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

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.

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

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

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

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

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.

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!