SOURCE LIKE
I_D,F1,F2
---------
100,N,Y
100,N,N
100,Y,N
101,Y,Y
101,N,Y
102,Y,N
103,N,N
104,Y,Y
105,N,N
106,N,Y
102,N,Y
105,Y,Y
O/P LIKE
ID flag1 flag2
101 Y Y
101 N Y
102 Y N
102 N Y
104 Y Y
106 N Y
Answer Posted / vaibhav
I think, here the question is... if F1 & F2 both are 'N' then the records with same I_D should be dropped.. correct Prasad?
if this is the case we need to find ans for this scenario..
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is size of a transaction and an array means in a datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the difference between datastage and datastage tx?
What are the different type of jobs in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
options available in sequence job to run,validate?
What are the different plug-ins stages used in your projects?
What is the process of killing a job in datastage?
What are the stages in datastage?
What are the different types of lookups in datastage?
Can you explain repository tables in datastage?
What are the some differences between 7.x and 8.x version of datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Differentiate between validated and Compiled in the Datastage?
Define meta stage?