How do you remove duplicate values in datastage?
No Answer is Posted For this Question
Be the First to Post Answer
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.
What are the important features of datastage?
why we use parameters instead of hard code in datastage
what are the types of nodes
What are orabulk and bcp stages?
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
how to validate the jobs
What is quality stage?
how to handle null values using transformer stage?
is it possible to access the same job by two users at a time in DataStage?