Hi Team,

Any update please give me a solution on how to successfully accomplish the job in TOS 5.1.1

Thanks and Regards,
Pavan

Hi Pedro,

As you suggested i tried using tParseRecordSet and tFilterRow instead of tOracleInput but the same JETException comes up and in the Code tab no code is generated.
Please help me out, due to this i am not able to accomplish SCD type 2
or Is there any other work around to accomplish SCD type 2?

There is a schema difference which displays in the warning what schema difference is there, how to debug what are the columns that are different from the select query?

I tried to print the output of Select query used in tOracleInput using a tLogRow and the output is displayed so this conforms that there is no problem with the tOracleInput component, but when i add tOracleSCD to Input component job is throwing an error

Thanks and Regards,
Pavan

pedro wrote:

Hi Pavan

I still remember I saw your complex query several days before.
The warning explains why you encounter this issue.
The columns in schema are different from those of this query.
You'd better check it.

Regards,
Pedro

Hi Pavan

You don't configure the tOracleSCD component completely, the surrogate keys is not set yet.  The surrogate key column generate a unique key for each record in the table. The job code will be generated correctly while you set the surrogate key.

About the warning message "the query is different from the schema",  you can edit the query that select column one by one and define its corresponding schema to see what's wrong.

Best regards
Shong

Hi Shong/Team,

Any updates on how to resolve the issue?
Thanks in advance!

Thanks and Regards,
Pavan

Hi Team,

Can any one help me why this error is coming? Please help me i am in dammn need for this.

Thanks and Regards,
Pavan

Hi Shong,

I thank you very much for your rocking answer, really this answer is very helpful and regarding Surrogate Key explanation i am spell bound.

Thanks you very much once again! I will definitely try and let you know the results.

Thanks and Regards,
Pavan

shong wrote:

Sorry for delay, I am busy with other projects these days.

I tried to manually enter the precision value between 1 and 38 by clicking the Edit schema button on the tOracleSCD component but that does not help, still the error comes, what should be done to overcome these error.

You don't define the precision for the column with NUMERIC datatype while creating the table or the precision value out of 1-38. You can see more information about this exception in the below topic:
http://www.techonthenet.com/oracle/errors/ora01727.php

To fix the error, you have to change the table and specify the precision between 1 and 38 for the NUMBERIC datatype.

Second question, Is it mandatory to define Surrogate Key in the SCD component, I have a SKU column which is unique so that column doesn't serve as the key for the job

Yes, you have to define a surrogate key to generate a unique key for each rows. The target SCD table looks like:
surrogate_id;SKU;name;start_time;end_time
1;1;shong;2012-07-04 10:12:11;2012-07-06 12:10:14
2;1;shong1;2012-07-06 12:10:14;null
3;2;Pavan;2012-07-05 10:12:10;null
4;3;Mike;2012-04-05 10:15:36;null
...

Here, the SKU column is the source key used to check that if the key already exists in the target table.

Last edited by tpk (2012-07-06 10:02:48)