DSXchange

Transformer Iteration is only included in Datastage 8.5 and higher versions.

Hi,
Which version of datastage you are using..??

Hi,
It should start from 1 in the second run also,not from the max value.

Ray , I am checking for the sequence,if its available,I think we can use it in insert statement in Oratgt and Orarej.

Hi Bob,
I think sarrogate key generator/file will only ensure unique records,but it will not give sequence number,initially I tried with that but it did not work.

Hi Kumar, Conceptually it should match,since once you apply HASH partition on the input of key columns,it generates hash value and it will make sure that it lands up to same partition.With partition you should sort the inputs with null first.In case all joining columns are null,it is pointless to pe...

Hi Kumar, Answer1:-Yes if you are joining on Two columns you need to specify both the columns into a join stage. Answer 2:- It depends upon your data.If you define Hash partition on only one key column and it has few groupings,may be all your data will land up to one or two nodes and other nodes wil...

Hi bob, Thanks for your solution,but I what about the missing seqno in TgtOra.let's take our same example.With the solution given by you,I can generate 1,2 for RejtOra but still in my target 3,4 sewno will be missing.my reqt is to acieve below output:- TgtOra 1 2 3 4 5 6 7 8 RejOra 1 2 If I am able ...

Hi Bob,
Yes you are correct,but PL/SQL out will be different.If input has 10 records and in that 2 records are rejected to Hspt,is should generate below sequene numbers:-

TgtOp
1
2
3
4
5
6
7
8
RejOra
1
2

But current deisgn will give below output:-

TgtOp
1
2
5
6
7
8
9
10
RejOp
3
4

Hi, I have requirment of migrating PL/SQL codes into datastage jobs.My source and target are Oracle. In PL/SQL code while loading data into targtet table ,seqno is generated in insert statement using stored proc and in case of exceptions its again called.Sql code is like this:- "BEGIN INSERT IN...

<removed by Moderator> :!: Prasoon and anyone else - please do not post contents from other sites or documents here, there are legal and copyright ramifications to doing that. Rather, link to the site / information in question. For example, the information that you copied verbatim came from an IBM R...

Hi Chandra, Below is the design:- Seqfile----> ColGen---->Aggregator--->SeqFile Generate DUMMY column with value 1. In Aggregator perform below derivation:- Grouping Key:- AgeGroup Aggregation Type :- Calculation Column For calculation:- DUMMY Sum Output Column:- Count Column For Calculation:- Balan...

Hi,

Ok i tried to run below code in dsjob:-

dsjob -user <user name> -password -<password> -server ETLServer -log dstage1 jobname

Here also i am getting previous logs.So how can i get most recent log's event id.

Hi, I am trying to write a query to get the latest log from xmeta table.My datastage version is 8.0 SELECT * from XMETA.LOGGING_XMETAGEN_LOGGINGEVENT1466CB5F WHERE CATEGORYNAME_XMETA='IIS-DSTAGE-RUN' AND CIS2_XMETA='JOBNAME' This query is ginving me all log,current and previous run log.I am looking ...

Hi,

You can parametrize the xml file path and file name.We have done in the same way.

File path =#EVENT_XML_PATH#/#XML_NAME#.xml

and its generating the output file successfully.

Please check with your path,if it is correct in parameter.

Split the same job into two jobs.use datasets for staging write/read.