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 / krishnakanth.ch

yes... add a new column in the sql override by calculating
the count(*) to get how many times the record is repeating.
Using Router we can seperate them into two different
targets.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you take back up of repository?

1158


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

1121


Which means the first record should come as last record and last record should come as first record and load into the target file?

1070


What is sequence generator transformation in informatica?

1073


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2024


what is the Default Source Option For Update Strategy Transformation?

1233


waht type of interface is used for testing the data in informatica

2250


How do you update the records with or without using update strategy?

1111


can u give example for factless fact table

6640


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7442


How to delete duplicate row using informatica?

1041


How an expression transformation differs from aggregator transformation?

1037


What is lookup transformation?

1038


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1121


What are batches?

1094