DSXchange

Hi anton,

Did you find any solution or workaround. Please post it here. I am facing the same problem.

Thanks

its working good now. I missed to add and information that, there could be multiple child records with same identifier (Say there could be more than 010 record.) The job design is, 1. CFF Stage to extract all type of records(Header, Parent, Child and Trailer) 2. Transformer Stage (run in sequence) t...

Shank, I dont want to read the parent and Child records seperatly. the first three characters represents the record type. Parent record - 001 Child record - 010,020,030... Here , i am getting set of records with thhis combination. and i donk have any key to differentiate each group In the ablove exa...

I am having a fixed width file with different record layout. The file is having a hierarchical structure with a parent Child Relation. Example: 000HEADER 001PARENT1_COL1_COL2 010CHILD1_COL4_COL5_COL6 020CHILD2_COL7 030CHILD3_COL_8_COL9 001PARENT2_COL1_COL2 010CHILD1_COL4_COL5_COL6 020CHILD2_COL7 030...

I am getting the below warning in a update job using terdata connector stage Teradata_Connector_95: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed The Qu...

Hi All,
I am facing the same issue. Can any one have any solution for this.

Thanks in advance

The dataset was not properly loaded. Check the job that creates the Dataset

Do anyone have idea in, how to import the parameters from one project to another project??
IS there any ideas, Please let me know, Thanks in advance

It depends on the Hardware that you are using!!!

Check the precision value of all the columns in your table. Some records are error loading a larger string.
To resolve, increase the length of the colulmn.

No. Use separate Data Set stages and run them into a Funnel stage. The problem I have is I wouldn't know how many DataSets will be there. They will be generated dynamically. Today I may have 10 DataSets tomorrow it could be 20. Replace the dataset with sequential file as the target stage in the job...

The metedata in the table and the stages are not matched. The issues are resolved by changing the metedata in the stages with respect to the table structure.

But i am puzzled, why i couldnot get any error like "Column mismatch " or "Column not found"

Suggestions are welcome.

Forget to mention ,
The above mentioned job ran fine last week. Let me know if you need any othre information.

I am having a job design as follows, Oracle Enterprise Stage ---> Transformer ----> Netezza Stage Here, i am just truncating and loading the Neteza table from the table from oracle. We are not using any Query to fetch the records from ORACLE. We are using Read Method as "Table" In Target N...

Set the Parameter APT_operator_Combine to false, to know which stage is producing this error.