Search results for query: *

All, In my opinion, obtaining certification without having training AND product experience on a few projects seriously devalues certification. It should be impossible to get certification without using the product. It is as if a Medical student wanted to get a license to practice medicine...

RomaDTT, The standard practice is to engage Siebel Expert Services to perform an Siebel Analytics Sizing Review. The outputs of this review include detailed hardware and configuration recommendations uniquely tailored to your organizations needs. This information will ensure that your...

If you are running on Windows, take a look at the Windows Event Log on the Informatica Server machine and look for Informatica messages. Charles

ProDev, Here are a couple of suggestions: 1. Use a lookup transformation against your target table to get the MAX(PK value). Be sure that you have an index on this PK column. 2. Create a database table to hold transient batch related info. You can use a post-session stored...

jlakhani, If Informatica is running on a Windows server then do the following: 1. log on to the windows server. 2. Kick on the Start button, Programs, and then Informatica Server Setup. 3. Go to the Network tab and enter the new host name or IP address. 4. Go to Windows Services...

beksalur, There are two tasks here: 1. Calculate the smallest extent that will hold the entire object. SELECT SEGMENT_NAME, SUM(BYTES)/(1024*1024) MB FROM USER_EXTENTS GROUP BY SEGMENT_NAME HAVING COUNT(*) > 100; 2. ALTER TABLE / ALTER INDEX to "move" / rebuild the objects...

Marty, If you don't have privileges to select against dba views such as dba_tab_columns, you can select against user_tab_columns to see column info for tables in the current schema only. You will need to remove the owner column from the query as it is not exposed in the user_tab_columns view...

I don't know if Informatica 5.x officially supports Windows XP Home. I can tell you that I am able to run the full set of Informatica client and server software on my own Windows XP Home machine and it works fine. Charles

Most of my work is in Large to Very Large Data Warehouses. If I use AUTOALLOCATE, won't I end up with very large numbers of extents? Based on my experience, large numbers of extents result in poor performance with table scans, index builds, mass inserts, etc. I suppose if I were managing > 55...

ashcarrot, Stefan is correct, correlated sub-queries are the way to go. Especially if REPORT or KEYWORD tables are large. Assuming a 1:Many relationship between REPORT and KEYWORD, this should work. select rep_id from reports where not exists (select 'X' from keywords where reports.id =...

Edjiga, Try the rewrite below. The CASE becomes Oracle DECODE. The "sub-query" for saldo_ant needs to be moved to the FROM clause. Obviously I cannot test the solution without your schema. ****** create view vreportefin (empresa,reporte,descreporte,grupo,nomgrupo,cuenta,descgrupo...

bookouri, I agree with sybaseguru's points. LMT is definitely the way to go. You do need to know your table and index sizes to arrive at uniform extent sizes that are appropriate. You don't want your tables and extents to have too many extents (> 100 or so). On the other hand, you don't...

Biraja, You could also use an ISQL script, if you only need a character stream output. Or you could create an ODBC DSN and use MS Access, Excel, etc, to extract the data, if the data volumes are not to big. Hope this helps, Charles

MN, I built a couple VLDB Data Warehouses for a major healthcare organization using Sybase ASE 11.5. They were over 1.5 TeraBytes each 3 years ago. They are probably even bigger now. We were loading over 400,000 complex transactions per night into these things. Charles

cwkinney, Take a look at the Update Strategy transformation. You can use Constants to control the UPSERT activity. DD_DELETE DD_INSERT DD_UPDATE There is even a DD_REJECT to send rows to the reject file. You also need to set your Target Options to Data Driven in Informatica Server Manager...

KarynAngel, Sounds like the problem is around SQL Server tuning. I don't have any information that would indicate that Oracle would provide any improvement. Suggest you take a look at Spotlight On SQLServer from Quest Software. quest.com. This is a good tool to understand what is going on...

Regarding question number 1 - you can use shell scripts to drop and create indexes via dbms utilties, invoke an OS utility to pre-process a file (grep, awk, etc), etc, etc. Regarding question number 2 - only you can answer this. Good luck, Charles

If you are trying to combine Column 1 and Column 2, and insert the combination into the table, then use SQL*LOADER column EXPRESSION. If you don't want to load Column 1 and Column 2 to the table by themselves, define them both as BOUNDFILLER. This will allow you to use the data in the input...

Ron, Please provide: 1. Number of rows in table before insert. 2. Average row size in bytes. 3. Number of rows to be inserted. 4. Number and type of indexes on table. 5. Number of extents for table and each index. 6. Tablespace parameters for table and indexes. a. Local or...

When you start the Informatica service, does it seem to start, but them stop after a minute or so? If so, are you using DHCP on your machines? If you are using DHCP, then this could be your problem. When a new IP address get assigned to the host name AFTER you have installed Informatica...