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
- 7105 Views
- I also Faced
- E-Mail Answers
Answer Posted / bharath
Hi,
please find the below answer.
|------seq1
src---->trans-----
|------seq2
in transformer stage give constraint as follows
src.f1="N" And src.f2="N"
check other wise link on seq2link.
then you get..
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How to reverse the string using SQL?
What is a merge in datastage?
What are the some differences between 7.x and 8.x version of datastage?
What are the types of containers and how to create them?
How can we improve the performance in datastage?
Describe routines in datastage? Enlist various types of routines.
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Which warehouse using in your datawarehouse
Can you explain kafka connector?
What are sequencers?
What is the difference between the local container and shared container?
What is ds designer?
What are the different types of lookups in datastage?
what are the errors,warnings in datastage
