DSXchange

Hi, When i run the 8.5 version same job and tables in 9.1 using with Change capture, it is giving different record count in 9.1 pls find below stats 8.5 CreateDelta,0: Statistics: Before records : 25749 After records : 25970 Output records : 6418 Insert records : 707 Delete records : 486 Edit record...

ok, in this case how to identify the field which one is giving interruption among 20 decimal fields

same datatype same data using for 8.5 even, but no fail in that, why only in 9.1.2 while extracting the data.

giving error at oracle connector stage, it is the source stage

Moreover working fine in 8.5 with oracle enterprise, after migrate to 9.1.2 it is giving error with oracle connector.

Hi, Please some one tell to me how to solve below error issue. Same job running fine in 8.5, but giving error in 9.1.2 I know this is conversion issue, but not getting the exact solvation idea. The OCI function OCIStmtFetch2 returned status -1. Error code: 1,457, Error message: ORA-01457: converting...

yes, i have done linksort for both the links, after sort it is working fine.

Early i tried with one linksort, after giving for both, it is working fine.

Even i have done sorting in differencestage itself.
but same result

Early it was giving fine results without sorting data.

Hi, I am getting after passing the records to difference stage and the source count is 1540 and 2 source count is 6 RemoveEntriesInExceptionList,0: Input 0 consumed 1540 records. Input 1 consumed 2 records. RemoveEntriesInExceptionList,0: Output 0 produced 1539 records. Warnings ---------- RemoveEnt...

I have changed to sort mode instead of hash in Aggregator stage. by this solution is issue is resolved

Hi, Hi we are doing inner join with join stage, but result is not coming properly Ex: from source getting 400 records after join it is giving 5 records but as of our think it suppose to give 400 records. If i do same inner join with lookup, it gives 400 records result in output If i do same inner jo...

Hi, I am running the job without columns, we are passing the columns from shell script. In DataStage job using oracle connector - -- Sequential file (two stages only). while running the job it showing no columns defined for source table, but we are passing columns through shell script. to solve the ...

Hi,

I am using Tera data as a source and oracle as a Target.

I am getting Ustring issues it showing message like
unable to convert ustring to string and while converting UTF8 code data might be get truncation.

Please let me help in this case

please find design SQLserver Enterprise ---- using where clause transformer ---- trimming data copy stage Transformer ---- using constraints and distributing to 3 outputs funnel ---- funneling the distributed data from Transformer stage Dataset --- Storing data into dataset using 2 node set data vol...

we are maintaining the free space for temporary data, still coming this kind of errors some time.

Hi, I am getting below error and i am thinking below issue related to buffer space insufficient. can any one please help in this case. Filter,0: Fatal Error: Unable to initialize communication channel on JTRETLPRD1. This is typically caused by a configuration problem. Examples of typical problems in...