DSXchange

Hi , In oracle the data type for a column in a table is integer.I imported the table in to datastage repository by assisted approach . When I tried to define the columns for that table in source stage ,the data type of integer column appearing as decimal.and same case with date (original) and timest...

Hi job is like this , target is a dimention table ,we need to load the data from various sources to target table.In the job the target dimention table acts as a lookup table. Right now the dimention table is empty. after developing the,when executing ,it runs too long. it haven't stoped even we stop...

ArndW wrote:Have you though about just using 3 Oracle Enterprise stages and linking the 3 streams using a funnel stage? ...

Hi Arndw,
Is funnel stage accept the data from multiple sources of different structures?

Have you though about just using 3 Oracle Enterprise stages and linking the 3 streams using a funnel stage? ... Hi ArndW, Here I am giving the clear picture we are using oracle database as source. There are three tables like this.. 1 .Invoice_Details- INVOICE_NO NOT NULL VARCHAR2(10) INVOICE_DATE D...

Have you though about just using 3 Oracle Enterprise stages and linking the 3 streams using a funnel stage? ... Hi ArndW, Here I am giving the clear picture we are using oracle database as source. There are three tables like this.. 1 .Invoice_Details- INVOICE_NO NOT NULL VARCHAR2(10) INVOICE_DATE D...

ArndW wrote:You don't have much of a choice of stages - and that choice depends upon which database you are using. Do the 3 tables have a common key or column used?

Hi ArndW,

I am using oracle database and there is no common column in the three tables .

Hi We need to extract the data from multiple tables of different structure.There are three tables with different columns,we need to extract the two columns from first table,two columns from second table and one column from third table . can any one suggest which stage I have to use to read the data ...

Hi we are usng the odbc stage to read the data from the source (oracle) database ,it's works fine.we are using odbc stage to load the data into orcle database. But we got the error like this ODBC_Enterprise_0: When checking operator: When binding output interface field "CUSTOMER_ID" to fie...

better you can use the odbc connection .it will solve your problem R u suggesting me to use ODBC stage inplace of oracle stage or providing the connecting string option in the properties tab os oracle ,if so the connection string option is not appearing in the properties tab of oracle. if we take o...

better you can use the odbc connection .it will solve your problem R u suggesting me to use ODBC stage inplace of oracle stage or providing the connecting string option in the properties tab os oracle ,if so the connection string option is not appearing in the properties tab of oracle. if we take o...

Hi, we are using oracle enterprise stage to access the data. In stage properties tab only user name and password options are enable and connection string option is not available. when we trying to uase the view data we are getting the following error Error executing view data command path search fai...

Hi
we are using ODBC as target stage, and there is a column sn_key in the target ,it has values starting from 1 to sequence .....
That extra column is genarated and values pased in the target only.
How to achive that ?

sarangadhar wrote:You should logon to your system as local administrator.

If you are on Vista, local admin is different from normal admin. This may be true with XP as well.

Hi sarangadhar,
I installed the client components successfully.ie : I have the admin privileges.

ray.wurlod wrote:Which part of "Please contact your supplier" was unclear? ...

Hi Rey ,


while I am installing server componentsin the middle at 33% of compleation I am getting this error.

Hi, I am getting the folloing error while installation of Datastage server components. Setup failed to apply licence information Please contact your supplier with the details logged in C:\Ascentail\Datastage\engine\uvregen_output.log The specified folder contain the following information Command = u...