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? {with out using EXPRESION
transformation and sequence generator transformation?}<-this
is important

Answer Posted / usha

by using dynamic lkp its possible...

in dynamic lkp if we r having 2 records..
i will inser 1st record and will update second record...

when ever data inserted in to the target cache get
refreshed..

we ttake dynamic lkp..
by defaul..new lkp row port is added...

we should enable the associatve port...

here we should give the condition ..


in router we should give condition as newlkp=1--it will
insert...

if newlkp=0 means duplicate recorts

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain one complex mapping with logic? sales project?

6590


Under what condition selecting sorted input in aggregator may fail the session?

1056


During the running session, output files are created by informatica server. Enlist few of them.

927


Can anyone tell me the new features in Informatica 9 Version?

2030


Briefly describe lookup transformation?

982


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1019


What are the different options available for update strategy?

937


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7264


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1048


What are the different types of repositories created using informatica?

1059


What are connected or unconnected transformations?

1048


How to Create a folder using pmrep command?

1101


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

1056


Why update strategy and union transformations are active?

986


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1056