DSXchange

use sort stage .set sort stage property --cluster key change Colum is true

Is their any function similar to dtx in server edition in parallel to generate hexadecimal string?

How can we achieve this in PX?

Thanks in advance

what is the maximum number of keys allowed in sort and aggregator?

Thanks
Suraj

How can we achieve substring functionality in parallel edition?

I have checked with left and right functions. These are not working like substring in server

can u plz help on this

How ur ftp file from windows to unix? ru using any tools to do this?

ur getting box like character because of ur ftp tool by default selecting
Binary mode

While doing ftp u should select transfer mode is text

i tried with

Read method=user defined query like "select * from <Table>"

i can able to connect and view data

But not with read method=Table

i have just hard coded the value NSO_REF .their is no parameter

i have tried what u said,created a test table and tried to access getting same issue

i am using .

Oracle 11g and Datastge 7.5.2

Oracle 11g

Datastage 7.5.2

Please find output SELECT count(*) from sys.dba_extents; SELECT count(*) from sys.dba_data_files; SELECT count(*) from sys.dba_tab_partitions ; SELECT count(*) from sys.dba_tab_subpartitions; SELECT count(*) from sys.dba_objects; SELECT count(*) from sys.all_part_indexes; SELECT count(*) from sys.al...

Thanks lot

i got count is 259

In all cases we are concerned with the size of the reference datasets. If these take up a large amount of memory relative to the physical RAM memory size of the computer you are running on, then a lookup stage may thrash because the reference datasets may not fit in RAM along with everything else th...

As I am not a premium member I am unable to read your select query given in previous massage
Could you please mention query alone in you reply?

my schema name and user name is same that is NSO_REF

the grants are given to user NSO_REF only

we have a oracle schema called NSO_REF The following select privileges are given by dba GRANT SELECT on sys.dba_extents to NSO_REF; GRANT SELECT on sys.dba_data_files to NSO_REF; GRANT SELECT on sys.dba_tab_partitions to NSO_REF; GRANT SELECT on sys.dba_tab_subpartitions to NSO_REF; GRANT SELECT on ...

error is

TDOR 000192

'Could not determine the oracle version for partitioning'