Search results for query: *

The user might want to see the report based on attribute from WHSE_ITEM, ITEM and WHSE table. For e.g. From relationship tables the user would like to see, reports like whats the case size, the arrangement of the cases from a particular WHSE, for a particular Item. Now the shortcut joins will...

We are currently trying to find out as to what is the best practice to try to do joins between Fact tables and dimension tables. Lets take an e.g. We have 7 tables 1. ITEM Table (I1 as PK) 2. VNDR Table (V1 as PK) 3. WHSE Table (W1 as PK) 4. WHSE_ITEM table ( W1 and I1 as PK) 5. VNDR_ITEM...

Hi , Shortcut joins are working in one universe and not working in another. Lets say that I have 3 tables Table A, Table B and Table C. We have the following joins 1. shortcut joins from Table A to Table B. 2. normal joins from Table A to Table C. Now when we pull objects from Table A , B...

Hi While running sessions in Informatica 6.2 , the session fails abruptly saying : FATAL ERROR : Caught a fatal signal/exception FATAL ERROR : Aborting the DTM process due to fatal signal/exception. The same mapping was running fine in Informatica 5.2. One thing to note is we were using...

Hi , I would like some info on how to connect to Paradox. We will need to create a DSN. Which Driver to use to create a DSN? Is it that we need BDE installed on the PC which will have the Driver for Paradox? IS there any document of how to connect to paradox database through Informatica. I...

Hi , I am having problems in trying to import the source tables from the Paradox DB. I have made the required entry in the powermart.ini file. PARADOX=EXTODBC.DLL and I have created the DSN using Microsoft Paradox Driver (*.db). by specifying the Directory where the Paradox files exists. Then...

Hi, Is there any way in Informatica to carry out the following process: We need to load to load into a fact table lets say INVENTORY_FACT by doing a lookup on the ITEM_DIM table to see if the ITEM is present. So lets say we do a lookup on the ITEM_DIM table with the help of the field obtained...

Hi , Can we use Paradox as source in Informatica and get all the data from there to DB2 UDB database. I went through the informatica manual and to connect to paradox we just need to create ODBC connection. If we have to create ODBC connection then I guess it should be the same way as accessing...

Hi, I need to find out if we can install BO on a server which is acting as the Citrix Terminal Server. We should then be able to access BO from any PC by connecting through the citrix terminal server client. IS this possible? And also will there be any licensing issue. Will we need to get...

Thanks for the reply. Just one more thing I want to confirm. I hope there are no version issues with Informatica and Citrix Terminal Server. What I mean is we can use Informatica version 5.1 or 6 or 7 with any version of Citrix Terminal Server right? Can you please confirm this. Thanks for...

Hi, I need to find out if we can install Informatica on a server which is acting as the Citrix Terminal Server. We should then be able to access the Informatica from any PC by connecting through the citrix terminal server client. IS this possible? I know informatica works via the microsoft...