DSXchange

Can we combine 2 separate records coming out of source database or input and write only 1 record to the output database?

Are you expecting to see 1 record as output? If you are using a full outer join with 2 different key values (123 and 129) I would imagine you would get 2 output records - they don't join, so you couldn't get them on the same record. What exactly are you trying to achieve? How are 123 and 129 suppos...

ray.wurlod wrote:If num_rec is your join key you will NEVER see 000129 in a left outer join. In a left outer join you will only see matching key values (000123) or NULL.
This is the definition of a left outer ...

I am using a full outer join.

I have 2 inputs A and B which go through a join component. Input A Column Name : num_rec Data : 000123 Input B Column Name : num_rec Data : 000129 In my Join Component, my key is num_rec and I have specified an outer join type because in the output I want to see data from both the files. But I canno...

Is there function in the transformer by which we can suppress leading zero's?
E.g. I have a field containing the following data:
0000012345
and I would like the output to show up as
12345 only.

Thank you.

I have an input file name of which the date is a part. An example file name is: abc102307 (102307 which is todays date.) I know that we have date functions which we can use but that would be in the transformer. I would like to get the current date incorporated as a part of the filename before any pr...

Is there an environment variable or any other way where we can get the current date as a parameter?

I want to be able to use a particular field in a condition within a transformer without hardcoding the field name in the transformer.
How can I achieve this?

Thanks

I have a job where RCP is enabled thereby all columns are propagated dynamically. The column names change depending upon the data. How can I specify a condition in the transformer by not explicitly specifying the column name that is has to operate on? Can we specify an input column as a stage variab...

Or even nvl.

In sql I might have to use decode(if then else) statements to achieve this.
How can I do the same in Datastage as Transformer dosen't support 2 inputs?
Thanks.

Is there any way we can perform a join operation with a condition in the join stage? I have 2 tables which are going into a Join component. Now what I want is that if a particular record in Table A has a null value then I want to get that value from Table B and vice verca. How can I achieve this? Th...

yes I have one field as key.

I have 2 inputs say file1 and file2 to a join stage. Both the inputs have 6 fields. Now the output should contain 3 fields from the file 1 and 3 fields from the file 2. Fields in File 1 and 2 name address city state phone email Now in my output I would like to see name, address,city from file 1 and ...

I tried clicking on "this" but it takes me to a "Page Not Found".

Where should I look ?