Search found 21 matches

by prashanth.spl
Wed Oct 13, 2010 2:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: No Data Found for operational metadata
Replies: 2
Views: 1719

No Data Found for operational metadata

Hi, I am trying to generate report from IIS based metadata captured. 1. We have enabled the Operational metadata in administrator and generated the XML files. 2. We have imported the XML files to the repository. 3. I tried running the <JobRun information for selected JobRun> template report. But whe...
by prashanth.spl
Fri Oct 01, 2010 6:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key generator stage in datastage 8.1
Replies: 4
Views: 5600

Hi,

I have used the following options:

File Block size: System Picked

Generate Key from Last Value: No ( I tried Yes Also ..No difference)

Execution mode: Sequential
by prashanth.spl
Fri Oct 01, 2010 5:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key generator stage in datastage 8.1
Replies: 4
Views: 5600

Surrogate key generator stage in datastage 8.1

Hi, I am trying to use Surrogate Key generator stage using Flat file in Datastage 8.1. When i am generating for 10 records, first time values are coming as 1 to 10. Next time it is genrating as 1001 to 1010...next 2001 to 2010 next 3001 to 3010 ..... I am running the job in 4 node configuration. How...
by prashanth.spl
Sat Dec 12, 2009 3:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle MERGE statement
Replies: 1
Views: 915

Oracle MERGE statement

Hi,

Can we use Oracle MERGE statement in datastage?

i mean the following statement.

MERGE <hint> INTO <table_name>
USING <table_view_or_query>
ON (<condition>)
WHEN NOT MATCHED THEN <insert_clause>
by prashanth.spl
Fri Jul 24, 2009 5:33 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Defining a Data connection in information analyzer
Replies: 10
Views: 13096

Yes. This is the first IAdb connections connection ... And the uvodbc.config is avaialble in ANALYZERPROJECT..
by prashanth.spl
Sun Jul 12, 2009 3:51 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Defining a Data connection in information analyzer
Replies: 10
Views: 13096

Defining a Data connection in information analyzer

I am trying to Define a Data connection in Information analyzer. But when i am checking connection string listbox it is not displaying anything. I want to know from which location the system will get the connection string?

Thanks in advance