DSXchange

Well there is no option to uncheck. Its a add on module installation to existing datastage server.

Hi All, We are installing additional modules to IIS (IA/BG/FT). The setup we have is Domain and Repository in one server and Engine in other server. The Issue from the logs we are getting is : ----------------------------------------------------- FAILED: The DB2 installation directory /opt/IBM/db2/V...

Ray ,

Thanks for info...Now how to write in parallel if table is hash partitioned . I mean in connector stage what partition i should use to write in parallel(table is hash partitioned) or Enterprise stage.

Thanks.

I understand the accesses needs on system tables.

So , if i do hash partition on a key (same as in table) in connector stage , it will not run in parallel to load table(hash partitioned) since both are different.

Hi All, We are having Target oracle tables as hash partitioned. When using oracle connector can we read tables in parallel ? When i tried "oracle connector type" partition is used, its throwing out warning cant write and its performing sequential write. Also , i see "hash partition ty...

Ha , I thought isadmin would have all permissions... thanks.

Vivek

Hi All, Recently Information Server with IA (8.7 with FP1 ) has been installed and when using IA some options are missing from Main Menu. Analysis Settings / Sources /Import Metadata, options are missing from Main Menu . What is weird is another system having same 8.7 with FP1 has these options. Do ...

Ernie - Since my question is related to the concept on this thread : I am working on parsing xml which has two repeating sequences inside master tag with additional tags. I am using new xml stage in 8.7 . The design which i did was, two outputs from xml stage(one for each repeating group with key) t...

Ray ,

I got your point on config file , but i didnt get when you said ,
"smallest amount of data moved by parallel job is 32 kb".

Thank you.

Ernie ,

I have a question , When we are dealing with say 100k of records , does sparse lookup doesn't effect performance ?

Thank you.

Hi All,

For the ISD jobs can we can config file more than one node ?

The way i see is, will the ISD server has the capability to detect multiple nodes in config file or not ? or it just submits to conductor node and the processing inside takes in parallel.

Thank you.

Thanks Ernie for information.

Hi All, Iam working on 8.7 version ISD jobs. When we use lookup stage reference(Normal ), does for every request to service the data gets refreshed and loaded to memory or is it one time load ? Also , how does the behaviour of aggregator stages work if the data is broke down to packets before sendin...

Well, When i am running the job by just giving pipe name as file name,Job was getting hung.

On the server side i did opened pipe using cat<pipename but nothing coming through.

Vivek

Hi All , I am trying to write data to pipe using external target stage. But i am finding difficult in writing the syntax for writing to pipe in "Destination Program" property. What was the syntax to populate input columns to pipe ? I tried just giving pipe name but its reporting error. Tha...