DSXchange

I have a job which inserts/updates data in a table. I have one more job in which I want to update ONLY ONE column of that table.(The second job is only meant for this purpose) Im using a dynamic RDBMS stage to load the table and it is not allowing me to update only one column as it is asking for key...

Hi, I have to insert records into a dynamic RDBMS stage. Since the derivation logic for one column is different I have to use another link for it. Is there a way to merge this column along with the other columns and insert into the DRS stage. It seems like the 'merge' stage will not work. can anyone...

Thats working.... :D

Thanks Narasimha

I tried it and it doesn't work in SQL server.

Any other ideas?

Hey,

Im using a Dynamic RDBMS stage to fetch data from MS SQL Server.
I want to do a left outer join in the DRS stage.
It is possible using "User Defined SQL" .

But I want to know if it is possible to do it using "Generated SQL Query"

Can anyone help me on this?

Thanks,
Diya

Thanks guys....I cudn even think of such a simple logic..

Hi, Im trying to apply a decimal shift to the incoming data. Incoming column is Precision=6 Scale=0 Output format needed is Precision=6 Scale=3. That means I want to shift the incoming number 3 places to the right. Is there an inbuilt function/routine for this? Or can anyone tell me how to do that? ...

I tried to insert some records manually...and it is working fine...
the SQL query generated by DS is like this

'INSERT INTO dbo.Error_table (column names ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)'

No...Im using 'Generated SQL' by Dynamic RDBMS stage

Hey guys... Im getting the following error while trying to insert data(after creating the table through Dynamic RDBMS stage) into a table. Warning:"[Microsoft][ODBC Driver Manager] Invalid string or buffer length" Fatal Error:"SQLBindParameter: Failed to bind a parameter." I chec...

Thanks meena and kumar...

Kumar the stage variable logic is working...thnx

Hey I have an input column which comes in as a series of As Ps Xs etc ...for the first of each type I want to set the o/p clumn to 'Y' for all others o/p column shd be 'N'....I mean for the first A ishd assign 'Y' ....then for the first P....then for first 'X' like that...

Can anyone tell me how to detect whether a particular input column in a transformer has changed to a new value or not?

I just gave u an example.There are 1000s of records in the input table with so many types.For each type i should pick up the row in which 'value' is maximum and then assign vale 'Y' to the flag...for all other rows i whould assign 'N'.... so if there are 'x' types I will have 'x' rows with flag='y' ...

Guys, Im facing the following problem in the Transformer logic. I have two input columns to my transformer 'Value' and 'Type' I have one output 'flag' column which is to be populated as 'Y' or 'N' as per the logic below. "For each 'Type' I should assign the value 'Y' to the output flag for that...