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
- 7288 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
explain about citrix scheduling tool in datastage
What are the different kinds of views available in a datastage director?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the benefits of datastage?
Define Job control?
What is use Array size in datastage
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Whats difference betweeen operational data stage (ods) and data warehouse?
In Datastage, how you can fix the truncated data error?
Can you explain players in datastage?
What is staging variable?
How to read multiple files using a single datastage job if files have the same metadata?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the difference between validated and compiled in the datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
