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
what is the function in Transformer stage can act as Rank function in Oracle
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
What are stage variables and constants?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
How a server job can be converted to a parallel job?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
If you want to use the same piece of code in different jobs, how will you achieve it?
How many input links can you give to a Transformer stage?
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME