How do you remove duplicate values in datastage?
No Answer is Posted For this Question
Be the First to Post Answer
Whats difference betweeen operational data stage (ods) and data warehouse?
what is combinability and non combinability?
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
how to handle null values using transformer stage?
Define repository tables in datastage?
can we see the data in fixed width file? how can u change the datatype of fixed width files?
How to move data set from one server to other?what are the steps to follow to do this?
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
What are the types of hashed files in data stage
what is the function in Transformer stage can act as Rank function in Oracle
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none