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

How would you copy the content of one repository to another repository?

1030


Why do you use Mapping Parameter and mapping variable?

1776


update strategy transformation in informatica

1074


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1930


What are the differences between joiner transformation and source qualifier transformation?

1182


Explain your project of banking domian.

1658


Explain lookup transformation is active in informatica

1114


Tell me about MD5 functions in informatica

935


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2314


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2312


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1180


can you please explain me pre session and post session options?

7593


Explain the code page compatibility?

1076


What is the commit type if you have a transaction control transformation in the mapping?

1040


how many types of dimensions are available in informatica?

1111