DSXchange

thank you all the job was failing because of the warning limit though there were no warnings that were being generated initially....i cleared the status and log for the job and it starts raining warnings.....

Appreciate your help

Thanks,
Deepak

Hi, I have a job which runs fine with a lesser number of records without any warning messages but the same job fails when i test with 1000 records. The only message that is logged is Attempting to Cleanup after ABORT raised in stage Job1..Transformer_1 i have tried running the job after clearng the ...

Hi am trying to capture duplicate records i have sorted the records on the key and am using the following code as stage variables. Var = Key flag = If Var = Var2 Then "Duplicate" Esle "NO" Var2 = Var But this is not giving me the results Though i see in my debugger that var2 is r...

sorry for that...
starting this as a new thread....

Hi am trying to capture duplicate records i have sorted the records on the key and am using the following code as stage variables. Var = Key flag = If Var = Var2 Then "Duplicate" Esle "NO" Var2 = Var But this is not giving me the results Though i see in my debugger that var2 is r...

you might also want to consider the update frequency of your dimensions as a factor

Is there a way I could build transforms and have them shared across projects other than exporting and importing them?

Folks, I have two tables A and B. These two tables are created in such a way that Table A has a parent key relationship on few attributes in Table B and Table B has a Parent Key relationship on few attributes in Table A. I need to do destructive loading on these two tables every night.I now I can d...

Hi All, My target is ODBC and i have checked the option create target table but while runnig the job it is showing that target table cant b created.Please let me know the reason. Regards, RAGHU Guess the UserName you are using to connect to the ODBC target does not have enough privileges to create ...

No what i meant to say was that whether i would be able to build a query result set and have it reused to do multiple lookups without having to build the query result set every time i do a lookup.....

Hi,
Is there any way where i could reuse an odbc lookup other than using it as a hash file.??

No the other table just has the 3 key columns..... the job is working now....but then i dont know what exactly the problem was..... As it was just a group by clause .... i changed the query to a generated query and added the sum clause in the derivation as suggested by one of the responses above...a...

Well.... the job is quite not done....
it works when i just have this source write to a file....
but when i join this source with another table it continues to plague me with the same error............

well.....
Thanks for the help ....
I just had to tick the Group check box in the source columns tab.....

Ok here it comes....

select
dept_id,
sub_dept_no,
dept_seq_no,
sum(salary) as sum_salary
from
Employee
group by
dept_id,
sub_dept_no,
dept_seq_no

My source stage has all the four columns in the select clause...