Search found 12 matches

by vinu1103sharma
Thu Aug 27, 2015 8:34 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA
Replies: 1
Views: 4244

IA

I have create rule in IA, I have done binding for rule set for particular table.
But i don't know how can schedule so it will run and send matching and
un-matching data client.
Can any one help to automated the send report the result of rule set.


Thanks
vinu
by vinu1103sharma
Tue Jul 28, 2015 5:12 am
Forum: General
Topic: XSD in datastage
Replies: 3
Views: 2260

Thanks eostic,

Datastage is not database but we have functionality to read and write database, So i am hoping creating XSD for xml file functionality available or not in datastage tool.
by vinu1103sharma
Mon Jul 27, 2015 12:36 am
Forum: General
Topic: XSD in datastage
Replies: 3
Views: 2260

XSD in datastage

Can we create XSD in datastage ?
What are the way to create XSD in datastage or other tool?
by vinu1103sharma
Fri Jul 24, 2015 12:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output Stage
Replies: 7
Views: 7331

Can we create XSD in datastage ?
What are the way to create XSD in datastage or other tool?
by vinu1103sharma
Thu Jul 23, 2015 11:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to create database connection in Oracle connect
Replies: 9
Views: 8424

Hi All, I don't know, you are able to understand the connector issue or not. Same IP address/HOST name, i am able to connect in ODBC stage but not able to connect in ORACLE stage. If my tnsnames.ora file is not correct the i can't connect in ODBC stage also. I think we need to modify some file in da...
by vinu1103sharma
Thu Jul 23, 2015 5:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to create database connection in Oracle connect
Replies: 9
Views: 8424

Not able to create database connection in Oracle connect

Hi friends, Issue - Not able to connect oracle DB in ODBC stage but same database i can connect in ODBC stage. More description about issue -> Our DBA has changed the host name like abc@xyz.com to abc@pqr.org in oracle database. So we also need to update in our infoSpare server in tnsnames.ora file....
by vinu1103sharma
Tue Jul 07, 2015 6:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC - delete then insert
Replies: 7
Views: 7672

Re: ODBC - delete then insert

Hi, Now i am using only write mode = insert. In ODBC or Oracle we have one functionality like "Run before and after SQL statement" in in am using "BEFORE SQL STATEMENT" Insert command -> INSERT INTO "O2K"."CERT_TEMPLATE_BINDING"("CERTIFICATE_TEMPLATE_ID&q...
by vinu1103sharma
Tue Jul 07, 2015 2:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC - delete then insert
Replies: 7
Views: 7672

Hi,

In input file i did filter so when we run the job it ask for CERTIFICATE_TEMPLATE_ID and pick all same id records, So here hash will not work. i find solution, i will post
by vinu1103sharma
Mon Jul 06, 2015 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC - delete then insert
Replies: 7
Views: 7672

ODBC - delete then insert

Hi Friends, Requirement -: We are loading data into oracle database based on templated_id so before loading data need to delete recording for same templated_id. Implement -: in ODBC stage i choose write mode - "delete then insert" insert statement "INSERT INTO "O2K"."CE...
by vinu1103sharma
Tue Jun 02, 2015 12:40 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Not able to download and Run the Report
Replies: 4
Views: 5715

Re: Not able to download and Run the Report

<Moderator: removed duplicate example, modified wording>

I have updated the original post with details.
by vinu1103sharma
Mon Jun 01, 2015 11:21 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Column analysis Error
Replies: 3
Views: 4186

Column analysis Error

We are not able to Column analysis on entire table; therefore we are running it column by column. Request you to suggest if there is any alternate way or if we are missing any setting.
by vinu1103sharma
Mon Jun 01, 2015 11:20 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA Latency Issue
Replies: 1
Views: 3409

IA Latency Issue

While working on Information Analyzer we are facing enormous latency for every action. Latency is very high as compared to Houston. It takes 10-15 minutes to open any table/view while it takes very less time in Houston.