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...

How to extract original records at one target & Duplicate
records at one target?

Answer Posted / davan

sq-->sort--exp--riuder--tg1--tg2
In exp V_flag=iif(empno=p_empno,v_flag+1,1)--variable port
p_empno=empno--variable port
0_flag=v_flag--output port
In rouder o_flag>1 one target,default one target

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is index?how it can work in informatica

2083


How can you validate all mappings in the repository simultaneously?

1425


can we override a native sql query within informatica? Where do we do it? How do we do it?

1113


server hot-ws270 is connect to Repository B. What does it mean?

2653


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1188


What are the components of the workflow manager?

1182


What is data movement mode in Informatica and difference between them?

1183


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2414


What are different types of transformations available in informatica?

1058


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1315


What do you mean by worklet?

1115


What are the mapping parameters and mapping variables?

1272


What is the difference between informatics 7x and 8x and what is latest version?

1137


how tokens will generate?

2249


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1689