What is the method of removing duplicates, without the remove duplicate stage?
No Answer is Posted For this Question
Be the First to Post Answer
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
In merge stage can we update the values?
How you can fix the truncated data error in datastage?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
How we can convert rows to columns in datastage?
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
which r the connectors used in san?
What is the differentiate between data file and descriptor file?
What is the use of hoursfromtime() function in transformer stage in datastage?