DSXchange

Thanks Ray, In production, I may have a chance to handle more than 5 Millions of records as a result of Extract2. Considering your sugesting, one value(Timestamp from Extract1) would be assigned to all records coming from Extract2 - shows undisirable to be considered as better solution but acceptabl...

All,
Fact: Remove Duplicate Stage functionality can be implemented in a Transformer Stage.
Does this fact quarantee for improvements on execution time consumption or Bulk records handling or any specific options.
Please suggest me to have profound view on this.

All, Requirement: I have two different queries to be executed in a DB Stage(Oracle) depending upon the value of the user defined parameter(ModeOfSchedule) But the metadata of SQL execution is same. The syntax of the Queries is, Query1:(ModeOfSchedule="MID") Select T1.C1, T1.C2, T2.C3, T3.C...

All, Requirement : Extract Col1(DataType:TimeStamp) from Table1 where Col2="<value>". Based on the value of Col1, filter the records while extracting from some other table. In short: I need to pass the execution result of an SQL Query as the value of a Job parameter to the next DS Job havi...

I have 2 keys to remove duplicate stage. It is partitioned and sorted on these 2 keys. The next stage is a transformer stage, where i have used a same partitioning. From remove duplicate stage to transformer stage I have not propagated one of the key. Question: Will the records of previous partition...

This is the sample code. export DSHOME = '/appl/infoserver/Server/DSEngine' export APT_CONFIG_FILE = '/appl/infoserver/Server/Configurations/2node.apt' export APT_ORCHHOME = '/appl/infoserver/Server/PXEngine' export PATH = '%PATH%' : '/appl/infoserver/Server/PXEngine/bin' export ORCHBIN = APT_ORCHHO...

Hi, I am new to Datastage.I have to validate xml against xml schema.In XML guide, it is given that schemaLocation should be given as attribute in the root element of xml document.I have several doubts regarding this. 1)I cant alter the root element of xml input because it is generated by some other ...

Thanks. Just an info...this routine is one of the job activity in seqeucner. No need of setting environment variables. You are right. But when I open the routine in designer and tried to run that error was thrown. But when i ran the sequencer, routine was succesdful. Anyway problem is resolved but j...

In the routine I am check the record counts in dataset. If there is no record i am returning 1 else I am returning 2. After running my routine I am getting this error. Message to be logged is... > dsrecords /appl/infoserver/Server/Projects/ILOS_Online_Shopping/datasets/OS_vanavailability_001_ex_TMS....

Hi, I need a XML like this below. <GROUP NAME="DPT0001 Users"> <USER>1480000</USER> <USER>1480003</USER> </GROUP> <GROUP NAME="DPT0002 Users"> <USER>1480001</USER> <USER>1480002</USER> <USER>1480005</USER> </GROUP> . . Also Please note number of Group name (ex:DPT001 Users) recor...

Hi Scenario: I am generating a XML chunk as below My job looks like this... DS | \|/ transformer | \|/ XMLputput1 | Lookup --->XMLputput3 /|\ | transformer /|\ | XMLoutput2 /|\ | DS XMloutput 1: header XML XMLoutput 2: Chunk XML generation XMLoutput :Final XML generation <Order> <LineItem> <a> <b> <...

I have to validate an xml input in xml input stage and reject the xml if it is not well formed ,i am getting xml from a sequential stage , if i try to reject that xml its giving a fatal error called record is too big to fit in a block.max block length is ...

Thanks...You are right. Its working.

Thanks. As per the document, it says this command will wait until the sequencer finishes its task and then it returns the exit code. But I want the status of the job immediately so that I will check the status; if it is running I will wait for 1 more minute by sleeping and check status, otherwise I ...

Hi

I want to get the status of previous instance sequencer. If it is success then i need to trigger another instance of sequencer otherwise I should not trigger.

I need to do this logic in shell script.

can anyone help me which API I need to use to find the status of sequencer?

kamal