DSXchange

Hi, I have a job where i read the records from dataset, sort using sort stage, join with a table, then add some extra columns in a transformer and insert the records in the target Oracle table. Even if there are null values in the input columns, i just pass it as it is to the output table. do i need...

Ray, i didnt get what you are trying to say

In the input i have col A(Value xxx) and col B(Val yyy)

In the reference stage i have two rows with the following values

Key--Val
1 -- xxx
2 --yyy

Now i want to lookup Col A with val xxx in reference and Col B with Val yyy in reference.

HI,

I have two columns in the source that needs to be looked up to a single column in the reference. Can this be done in a single stage or we need to use multiple lookup stages.
Even if one of the lookups fail, i need that record in the reject link.

Hi, I have a job, where i extract a long datatype column from oracle Database. I tried extracting with Varchar(4000) and more and tried using Varbinary, but nothing works. I am getting the following error: main_program: Unsupported SQL type LONG or LONG VARCHAR for column TEXT. Is there a way to get...

Thanks for the responses..One more thing to ask..Is there a performance change if i update one field or 20 fields of a record?

no, that is not my requirement..

i have different conditions based on which i have to update different columns

Hi, From source i am splitting the records based on certain conditions and i need to update different columns based on the conditions. What i am doing is :Take all the columns from source,send to different links according to conditions, change the required columns and send to funnel and combine it. ...

Are there any performance issues if we use oracle sequences?..I heard that, it was one of the disadvantages of using an oracle sequence.

Is there a way to capture these records in a file or a dataset.

HI, I have 100 records in the input and i am doing an insert update in the target table. I want to capture the insert records and update records like we capture the reject records through the reject link. Is there a way? Because i want to update the status as Y for all the successfully processed rec...

Hi, I have Col A,col B and col C in input file. also Col A,ColD in Ref table. I am doing change capture between the file and the table and i want Col A,Col B,Col C and Col D in the output file. But in the output i am getting only ColD for taking as ouput. How can i get all the columns from input and...

yeah..But with the link variables i think we should be able to capture it from the transformer itself.

Since the key in table1 is a column which i am not going to use in table2, when i capture the rejects from oracle stage(table 2), i wont get that column with which i can update the table 1.

Hi, I want to capture the rejected rows while it is being upserted in a oracle table. Table1-->Transformer-->Table2. There is a key column in Table 1 and i want to update the records corresponding to the key column as Error_code=Y in table1 where i am not able to insert/update the records in table2....

Thanks Craig, but is there a reason that you would not prefer to have environment variables to be passed..
In one of the projects i did use it and found it to be very easy..so just curious to know the drawbacks.

Hi, I have a job which needs to be re-used with multiple parameters. The job has an oracle stage which extracts data and stores it in a file. I have the same table in different schema. So each has different value for schema/userid and password(Encrypted). All these values need to be stored in Datast...