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

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.

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

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

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

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?

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

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.

Thanks. Do we need to rebuild indexes in case of complete refresh? Also, in case of fast refresh, do we need to analyze the mat. view or the indexes?

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