DSXchange

Hi All,

I'm getting the below warning while I'm doing the lookup.

please let me know how to handle this.

Lookup_115: When checking operator: Operator of type "APT_OraLookupOperator": will partition despite the
preserve-partitioning flag on the data set on input port 0.

Thanks
Suresh

Thanks Sanjay for the response.

Can you please let me know how to resolve the Scratch space issue. Do i need to request my admin group to increase the space or is there any thing I can take care off in my job configuration.

Thanks
Suresh

I had a job in which I used four join stages, I was using left outer in all the joins. Two of my right table are much bigger then the left table, (Approx 20 million and 8 million on my right tables). Job was running fine and taking 18 minutes and some times getting failed because of resources.It was...

Thanks Ray,

Hi, I have a job which need to pick the value of the latest time stamp. value_Column Timestamp 1, 2007-03-21 00:00:00 1, 2007-01-01 00:00:00 1, 2007-02-05 00:00:00 2, 2007-03-03 00:00:00 2, 2007-05-05 00:00:00 2, 2007-05-05 00:00:00 2, 2007-01-11 00:00:00 4, 2007-05-21 00:00:00 4, 2007-02-22 00:00:0...

Hi,

I have string for which I have to do the lpad.
Sql I can have lpad(ABC,18,'0').
eg :
1) 5324
000000000000005324
2) 123
000000000000000123

How can I achive the same in Datastage.

Thanks
Suresh

Hi, I'm doing the Sparce Lookup in one of the job. Job is not throwing any warning or error message but always job is in running mode in director and when I see the performance on DS client it is showing 0 values on the link. my question is why it is not reading the records, If there is any problem ...

Hi All, I'm trying to do a sparce lookup on one of the oracle table. Oracle stage I defined the Sparce lookup. In lookup stage when I try to define the key derivation datastage is not allowing me to do it and it throws one alert box with below message. key expressions cannot be set on key columns of...

Hi GURUs, My project "XXXXXX" wants all date time functions to be in CET(central european time), like all the date/time things on the report should have CET. But the job will be run in USA,which is Eastern standard time(CET = ESt + 6 Hours). Now the problem is if there are like 1000 record...

thank you Ray for providing help in this regard and clarifying my query.
One thing that will not happen is the SELECT priviledges to the Tables since that has been the case all the time.

thanks once again..

Ray, Now, I am getting an idea about what I am doing. I ran the following queries to see if the Partition view information is available but did not retrieve any rows. SQL> select TABLE_NAME, PARTITION_NAME FROM DBA_TAB_PARTITIONS where TABLE_NAME like 'V_POS_SUM_DLY% SQL> / no rows selected SQL> sel...

Thanks Ray for the information. Oracle DBA has mentioned that the view is partitioned and that this view is partitioned based on one of the fields in the view. In the Partition table property ,I mentioned the same view name as that I used in the SELECT statement. Can a view have a different view whe...

I am getting the following error, when I use Partition table property on Oracle Stage to partition a View. APT_OracleRowid8PartTable: failed to get the block count. Oracle_Enterprise_138: Errors were encountered partitioning table V_POS_SUM_DLY_R. I have SELECT permission to all 8 Systems table. Fir...

Hi,

I have a numeric column in the backend.
values for this looks like below :
00000123
00000456
00000789
in datastage I need to trim to look like below:
123
456
789
can some please let me know if there is function.

Thanks
Ram

Thanks Ray for your quick responce. I doing the left outter join. I have 1 to many relationships from left to right. How can I accomplish this in the job ( Do I need to Pivot the records). This job is for delta loads In my left table I will get nearly 60,000 records every day. If I pivot this then I...