DSXchange

Craig, Amazingly good, it worked. I was not using any user defined SQL so I followed the second option of switching to column generated, and clicked build button to change something... That really worked well and I have the job running fine. The only problem is that the job is taking little longer t...

Hi All, I am trying to pull 100,000 rows from ORACLE. I need to do some simple tranformations and send it to ORACLE Target. Oracle Version : 9.2.0.1.0 DS version: 7.5.1.A The Design is simple: SRC_ORA-------------->Transformer------------>TGT_ORA I am getting the following error when I try to view t...

Hi Guys, The problem was with installation. For some reason the installation did not go well I feel. I actually tried to uninstall it but could not as the Profile stage client was not uninstalling. I had to finally request for a freshly configured system. I followed theinstallation manual and insta...

Hi, After you have gone through the docs, I feel working on the tool is fairly easy. The installation is little confusing and tricky, Otherwise you should not have any problems working with the tool unless some specific functionality needs to be achieved. I have profiled varied ranges of datasets w...

Hi All, Thanks a lot for all the responses. I am now able to get it worked. The system name was changed for some reason so that had actually messed up the TNSNAMES.ORA file. So I had to Make the correspoding changes to get it working. I never used IP address, but used only host name while creating t...

Hi All, I have seen that the logical database that we create to store the metadata in ProfileStage are tightly associated with the repository user name. I needed to understand how is it possible for multiple users (different users) to connect to the same profiling repository. Also, Can any please te...

Hi all,

Thanks a ton!

That helps a lot guys.

The link had whole bunch of manuals.
Appreciate your help.


Thanks,
Arvind Chenna (Ac)

Hi all, Does any one still have access to Orchestrate documents? I need to clearly understand the message flow or the communication mechanism between the Client and the Orch or PX engine. I feel that the installation guide or the config guide for Orchestrate might be useful for the purpose. Any out ...

Hi Everybody , I need to import the metadata of the tables into profileStage from a text file/folder and some realtionals sources. I have created a DSN using Ascential data direct drivers and pointed it to the datasource. I am able to get data from TXT databases without and problem and also able to...

Hi all, We have Datastage and ProfileStage running on a WIN NT Server and planning to migrate to EE or the PX. I need to substantiate with enough facts and figures that PX will boost the performace of the jobs. I also need to know if the EE or PX can have server installed on WIN NT or do we have to...

Hi all, We have Datastage and ProfileStage running on a WIN NT Server and planning to migrate to EE or the PX. I need to substantiate with enough facts and figures that PX will boost the performace of the Profiling jobs. I also need to know if the EE or PX can have server installed on WIN NT or do w...

Hi, ProfileStage is not able do a complete analysis from both the directions of the relationships when Cross Table analysis is performed. Still need to figure out how to make it do the complete analysis in both directions. I have checked all the menu options to see is there is any way to work with a...

Hello everyone, I am new to Ascential ProfileStage. I going through the tutorial and performing the tasks. After accepting the Primary key Analysis, when I try to perform the cross table analysis I get a different result from that is given. I have considered to profile 3 subject tables. "emp&qu...

-->SAP Business Information Warehousing has " HOW TO" seminars and Document releases. -->These are publicly available. -->I had used them -->Similarly, Ascential has a practice of making best practice documents. -->These are available only for the customers. -->I have a friend who worked f...

Loading the data drivers from ascential is the only way to do that.