DSXchange

Hi,
If the primary key field is specified as NULLBLE=YES in Oracle then please do a SELECT COUNT(*) check in your table to find out the Null counts for that column.

Cheers
Debasis

REDHAT LINUX ... RHEL4 U6

Hi,
I am trying to install IIS v8.5 on Linux but getting following prerequisite as FAILED...Ensure the Current Platform is supported Platform.

Details of the error is

Linux Version 2..6.9-67.Elsmp is not supported.

Any help regarding this will be appreciated.

Cheers
Debasis

Hi,
I think there is miscommunication. What I want to say is the Orchestrate Tag in a XML export.. I wanted to know from where these information are propagated.. Anyway I got the answer. Thanks Ray for all your valuable inputs... .. Be nice...

Thanks Ray for your response. I understand that at design time these informations are not stored in any of the tables. Lets assume that I designed a job with partitions and saved and compiled it. Then I will take the export of the job in either dsx or xml format... So bit curious to know how the xml...

Hi, I am aware of system variables.. But I need information about partitions (hash, auto,.. etc) used in an existing job. The Universe table which stores this information specific to the job is required.. For ex... If in a job hash, auto, same partitions are used.. Then while exporting the job we co...

Hi,
I want to get partition information used in a job. Just wondering which Universe table has partition information along with link name in a job.. Or is there any other procedure to get it.

Thanks
Debasis

Hi,
Then in which case "Main" will come into consideration for Join stage?

Thanks for your reply.

You are right. In the above example both the input links are having identical partitioning. If both the input links are not having same partitioning then in the join stage how will I know which one is "Main" link.

Hi, I am using a join stage .. There are two input links to the join stage and both of them are sorted and hash partition based upon a key COL1.. In the output I used same partition.. I want to know which input link partitioning information will be propagated to the output link(as it is same partiti...

Hi, In our project we are using Oracle enterprise stage. While reading from Oracle I saw it is reading 33000 rows/sec. But in some jobs while inserting it is 33 rows/sec to 100 rows/sec. It is very slow. And the operation at target table is Upsert. This is a sort of performance improvement project. ...

Hi, I am using FTP Plugin stage and trying to FTP a file (which contains approx 21 millions of records) from Unix to Mainframe. But each time after sending approx 100 thousands of records it is giving me the following error. Any idea to resolve this issue ?? FTP_Plug_in_39,0: Info: TestJob.FTP_Plug_...

Hi, Can you tell me what is the max size limit to create a sequential file thru datastage?? Is there any way we can increase the sequential file size limit. Becasus if I am going to extract the records from the table based upon partition I assume each file will be more than 3 GB. Is it feasible thru...

Hi,
I have to extract more than 400 millions of records from an Oracle table to sequential file(s) and FTP the file(s) to Mainframe.

Can someone suggest me what is the most feasible solution.

Thanks
Debasis

Hi, I have to rename my job category. And all the categories are having subcategories. My requirement is ... To change Job1\sub1 to Job2\sub1 Job1\sub2 to Job2\sub2 Job1\sub3 to Job2\sub3 .... like this. I used UPDATE DS_JOBS SET CATEGORY='Job2\sub1' WHERE CATEGORY='Job1\sub1'; ...etc etc But I have...