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 / p1khatri

using Dynamic lookup :-
for new record (i.e. Newlookuprow =1)insert into tgt 1
for duplicate records (i.e. Newlookuprow=0) insert into tgt
2

I hope this'll work

Is This Answer Correct ?    7 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2038


Write the different tools in the workflow manager?

1070


Is it possible to define a single node as a Gateway node as well as worker node?

1123


Explain the tuning lookup transformation - informatica

996


What are the designer tools for creating transformations?

1119


Informatica settings are available in which file?

992


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

2305


How you can differentiate between connected lookup and unconnected lookup?

1064


COM components can be used in Informatica

2395


Why union transformation is an active transformation?

1049


How can you validate all mappings in the repository simultaneously?

1372


Explain incremental aggregation in informatica

1134


What are the differences between source qualifier and joiner transformation?

1064


How an expression transformation differs from aggregator transformation?

1044


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2188