DSXchange

Hi, I'm facing an error with Oracle Connector stage. "The variable nAccessorIndex has value -2 which is not valid in the current context. (CC_OraRecordDataSetConsumer::getAccessor, file CC_OraRecordDataSetConsumer.cpp, line 5,713)" Please help on this. Couldn't find info about this error o...

Thanks Andy.

Thanks Ray.

Also is it fine if we do partitioning (Hash) on the source link alone or is it required on both source and reference link?

Please clarify.

Hi,
I've a query on Slow Changing Dimensions (SCD) Stage.

Do we need to sort the data (on the input links) on the Business Keys being used in the stage?
Is it mandatory for proper functioning of SCD stage, like we do for Join and Merge stages?


Thanks.

Thank you.

Hi, Till date, we were loading data to Teradata DB and now we've decided to move to Exadata. What are the steps to be taken care of while modifying the Datastage Jobs? Can we use the Oracle Connector stage for loading data to Exadata? or anyother alternate approache? Earlier in Teradata, we were col...

Hello Everyone,
Is it possible to cleanse County column through CASS and GAV stages present in QualityStage.

Till date, we were cleansing Address, State, Zip, Country etc fields through these services. Just wanted to know whether COUNTY can also be cleansed or not? Please help on this.

Hello Everyone, I don't know whether this topic is already discussed, but i couldn't find it in the search list. I have a datastage sequence which contains 10 jobs and say suppose in 3 rd(source having 10000 records) job after loading 9000 records to target, job got aborted. Now when restarting the ...

Hi,
I've imported the xsd and defined the key column in meta data. Please help on steps to be followed in XML Output Stage

Please help on how to configure the XML Output Stage for this requirement.

Hi, I've a requirement where i need to extract the data from Flat file and load it to XML File. The sample XML File given to me is mentioned below. Please help me on this. <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> - <report xmlns="http://www.***.com/...

Please explain me how to do this.

Thanks in Advance.

Hi, I have a requirement where to load data coming from multiple sequential files to different target tables. The table that need to be loaded for a particular file will be available in a lookup table where we'll lookup on file name and get the table name that needs to be loaded. My query is how to ...

Hi All, I am inserting the data into oracle table by using the odbc stage. Say employee_name table, There is after insert trigger on the employee_name table for inserting the data into the employee_sports table ES_ID, Employee_name, Sports ES_ID is primary key This trigger works like below For every...

Hi, I've a requirement where i need to convert Semicolon to '**' value within braces present in a column. I might also have Semicolon which is not included within braces and it should be retained the same. The number of Semicolons within braces are dynamic. For Ex: London University; Harvard Univers...