Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 7106 Views
- I also Faced
- E-Mail Answers
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 are the steps needed to create a simple basic datastage job?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Where do the datastage jobs get stored?
What is the flow of loading data into fact & dimensional tables?
What are the features of datastage flow designer?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Which warehouse using in your datawarehouse
Define Data Stage?
What is the sortmerge collector?
Differentiate between odbc and drs stage?
What is the difference between passive stage and active stage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Why do you need stage variables?
What are the repository tables in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
