Thanks chulett
There are no index build on table and i am running Update job then insert job in sequence.
Search found 126 matches
- Fri Jan 31, 2020 8:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Snowflake table updating very slowly
- Replies: 3
- Views: 5261
- Fri Jan 31, 2020 3:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Snowflake table updating very slowly
- Replies: 3
- Views: 5261
Snowflake table updating very slowly
Hi I am trying to Update and insert a table in Snowflake via separate Jobs. Update is taking long time and not finishing in Monitor it says only 1 row is being processing all the time and it didn't go more than that. I am using ODBC Stage and updating the data using 3 key columns and 5 non key colum...
- Thu Oct 26, 2017 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Access problems on Excel file
- Replies: 4
- Views: 4199
- Wed Oct 25, 2017 4:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Access problems on Excel file
- Replies: 4
- Views: 4199
Access problems on Excel file
Hello I have excel file to be processed in datastage. I used Unstructured stage to read data from Excel file but I am getting error saying: file <xxx> doesn't exists. Specify a valid filename I know there is file in location I mentioned in Unstructured stage. I am running DataStage job as non-dsadm ...
- Tue Sep 26, 2017 6:22 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: DSN Error
- Replies: 1
- Views: 15960
DSN Error
We are experiencing an issue with IA where I am trying to import flat files metadata to IIS Repository. I have created DSN, I was able to test using DS_CONNECT Successfully. Created Import area in IMAM where it creates schema. But When I try identify flat files in IA, it throws an DSN Error as below...
- Thu Jul 27, 2017 3:48 pm
- Forum: General
- Topic: Virtual Memory v Swap
- Replies: 3
- Views: 4379
- Thu Jul 27, 2017 3:45 pm
- Forum: General
- Topic: Exceptions Console
- Replies: 0
- Views: 3100
Exceptions Console
Hi we are planning to use Data Quality Exception Console to monitor for Exceptions management. we are new to this, so tried creating simple job which will write records to Exceptions Stage, then saw the Exceptions Console but couldn't see any exceptions. I think i need to create events if i remember...
- Tue Jul 25, 2017 4:55 am
- Forum: General
- Topic: Virtual Memory v Swap
- Replies: 3
- Views: 4379
Virtual Memory v Swap
Hi
I searched in google to find usage of virtual memory and Swap in InfoSphere but couldn't find much information.
and also I want to know what is the rational behind allocation for these two(How much need to be allocated and on what basis)
Can someone give some details on it.
Thanks
Naga
I searched in google to find usage of virtual memory and Swap in InfoSphere but couldn't find much information.
and also I want to know what is the rational behind allocation for these two(How much need to be allocated and on what basis)
Can someone give some details on it.
Thanks
Naga
- Tue Jul 18, 2017 2:33 pm
- Forum: General
- Topic: How to make dsadm user as part of LDAP account
- Replies: 9
- Views: 8087
- Tue Jul 18, 2017 12:05 pm
- Forum: General
- Topic: How to make dsadm user as part of LDAP account
- Replies: 9
- Views: 8087
- Sat Jul 15, 2017 3:59 am
- Forum: General
- Topic: How to make dsadm user as part of LDAP account
- Replies: 9
- Views: 8087
- Thu Jun 01, 2017 3:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter Set
- Replies: 1
- Views: 2753
Parameter Set
Hi When I create parameter set for Database credentials for each schema, which method is better Parameter Value Set file? or Environment Variables? What are the advantages of one on one? I used value set file in every project as it is flexible and don't need to login to DS Administrator to change th...
- Tue May 30, 2017 2:18 pm
- Forum: General
- Topic: Admin Access
- Replies: 7
- Views: 6366
- Fri May 26, 2017 2:35 am
- Forum: General
- Topic: Admin Access
- Replies: 7
- Views: 6366
- Mon May 22, 2017 5:09 pm
- Forum: General
- Topic: Admin Access
- Replies: 7
- Views: 6366
Thanks to both I am still in doubt as far as i remember. I didnt assign rights to projects in DS Admin as we are assigning all roles to user earlier in different clientand worked fine. Also, DS user is not created on Server or not given any rightsto server. We have different users on server. As i me...