Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

How many types of sorting methods are available in datastage?

1060


How do you start developing a datastage project?

1089


whom do you report?

1913


Which algorithm you used for your hashfile?

1166


State the difference between an operational datastage and a data warehouse?

1121


What is a ds designer?

1058


What is the difference between passive stage and active stage?

1507


how to write server Routine coding?

2100


What could be a data source system?

990


How to read multiple files using a single datastage job if files have the same metadata?

1222


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3105


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2957


Define APT_CONFIG in Datastage?

1061


How many types of views are there in a datastage director?

1272


Lookup constraints

1236