DSXchange

Hi All,

Could you please suggest me how can I get Trailer record count in data stage? and how can I append to the sequential file?


Thanks for Advanced Help...

Thanks for your reply.
I got output.

Hi,

I have one requirement .

My Source is

7/29/36
9/12/82
5/18/64


I want output is

1936-08-29
1983-01-09
1964-06-18

In the above example month should be increment by 1.

Hi All,

How to concatenate the two query data output

Example column1 as 1st query output,column2 is second query output.

column1
-----------
1000
2000
3000

column2
--------
1111
2222
3333
I want to concatenate two query outputs in DB2 database..
Please help me the same.

Thanks Ray.... working fine

Hi All, I have one requirement. Requirement: Take the current date and check the date if day is >20 then take the month as current month Else take the previous month with day as 01 always. Ex: 21-02-2014 .here day is greater then 20 output= 01-02-2014 02-03-2014 here day is less than 20 take the pre...

3 rows (third row all columns are showing NULL)

Joining is putting NULL.

Hi ssnegi,

I used Full Outer Join not Left Outer Join.

My Transformation condition is

If IsNull(dslink.left.empno) then dslink.right.empno else dslink.left.empno

Hi ssnegi,


I designed Job same like above but I am getting output is

Empno | Ename
101 | ABC
102 | BBB

Hi All,


I have 2 input files. I want to compare two files and remove duplicates from the 2nd file and merge the files into single file.



input1

Empno | Ename
101 | ABC
102 | BBB


Input2

Empno
101
103

Output
Empno|Ename

101 | ABC
102 |BBB
103

Hi All,

How to get link count(source, target, intermediate and reject) in data stage .

If possible please write link count routine or script and help me....

Thanks for your advance help....

Hi All,

I have I/P is

EMPNO
1
2
3

I want O/P

EMPNO
1,2,3

Union ALL will not work.I want to split the columns did you see my output?
empno |salary|Alias salary
103|NULL |0000000
101 |100000|NULL

Hi All, Empno|Ename|Salary|Location 101 |Reddy|100000|Hyd 102 |John |200000|Delhi 103 |peter|000000|bangalore One column need to displayed into two columns as per the below queries Select empno,salary from emp where Ename =Peter select empno,salary from emp where Ename=Reddy based on the above condi...