DSXchange

Hi, I met with a strange behavior in one of my jobs. Attached is the job design, it extracts around 100 million records from one source and around 75 million records from another one, then trying to inner join them. I was using Hash partitioning on the join keys and 'Stable Sort' option in the join ...

Dears, I have created the a C++ function to convert from hexa-decimal to decimal, compiled and used this function as an external routine in Transformer in Linux environment without any issue. But when i tried to do the same on an Windows 2008 R2 Enterprise edition, compiled the .cpp file using : APT...

Hi, I can't generate XML file with the below format. <ns2:SyncRec> <ns2:SyncInfo> <ns2:Details> <ns2:Rec> <bas:Id> TEST </bas:Id> </ns2:Rec> </ns2:Details> </ns2:SyncInfo> </ns2:SyncRec> </SyncGetRsType> <ns2:SyncRec> <ns2:SyncInfo> <ns2:Details> <ns2:Rec> <bas:Id> TEST </bas:Id> </ns2:Rec> </ns2:De...

vamsi.4a6 wrote: which NLS Settings we have to use?

'ISO8859-6' suppose to work fine.

For second point, I've tried multiple NLS until it has worked with 'ISO8859-6' on one schema and 'UTF8' on another one.

I think choosing the right NLS is dependent on your database's NLS character set.

Regards.

Good news for LONG as well!

It has worked with the same configuration except that source stage has to be Oracle connector stage because it's a MUST to 'Enable LOB references' to make it works.

Also it has loaded Arabic data with NLS of 'ISO8859-6'

Regards.

Hi, At my project, we had to migrate CLOB data including Arabic data and we've successed. I thought of sharing my experience, it could be useful for anybody. We've followed these steps to load CLOB: 1. Source stage is Oracle connector or DRS connector stage. If Oracle connector stage is used, don't ...

Another option is to use the sort stage to add a key change indicator to the row and use that to reset a counter. Thanks Mike. I've used this approach and it's worked . 1.Sort and partition input data based on type column 2. Generate keychange column from the sort stage. 3. Create an integer stage ...

Try a sufficiently large enough test dataset. Thank you Mike and Nag for reply. You're right, Mike. I've tried with 1 million records into database table and it didn't work. Now how do you think I could achieve the requirement? (i.e. reset a counter at every new type with keeping the parallel execu...

I had a requirement to create a counter and it should be reset at every different type, as follows: Type, Counter A, 1 A, 2 A, 3 B, 1 B, 2 C, 1 C, 2 I found some difficulties at the beginning because I need to keep the parallel execution mode and job runs on 12 nodes. But the case has solved once I ...

what exactly you want to look at?

DataStage client version: 8.5
Oracle version: 11

Hi, I'm trying to read data from Oracle using parallel mode, my table is not partitioned so I'm using 'Rowid Range' option after enabling the partition reads features at Oracle connector stage. The job was working fine at Dev server and reads were in partition mode, but after migrating to Prod serve...

chulett wrote:Clarify for us what exactly "they're not defined at job" means.

It means that those columns are not defined at DRS stage metadata.

Considering the above example, I insert data into the first column only from DataStage and the other columns are left to database to handle.

I'm using DRS stage as a destination to insert or update data. The problem that it generates insert or update statement for every column at the destination table although they're not defined at job! Example: 1- table has three columns 2- one column only is defined at the job but generated insert sta...

Hi, I want to implement the SQL 'IN' logic using a data rule in IA. The business case is: Inputs: - An account has more than one asset. - Account and asset both have a status. Required: - If the account status is active, and at least one asset has an 'Active' status, then the rule is satisfied, else...

Thank you chulett for your replies; however, I couldn't read any of your suggestions it's hidden as a Premium content

how can I read them?!