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 delete duplicate records in a flat file source?

Answer Posted / sushanth1234

Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

define galaxy repository in informatica

2209


Where can we find the throughput option in informatica?

1045


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2334


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8188


 Informatica Checkpoints

3312


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2184


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2119


what is index?how it can work in informatica

2030


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1944


What is aggregator transformation in informatica?

926


can u give example for factless fact table

6604


What is resilience time?

1111


What do you mean by enterprise data warehousing?

1041


tell me 5 session failure in real time how can you solve that in your project?

2272


Briefly explain the aggregator transformation?

985