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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

how eliminate the duplicates in flat file with out using
sorter ,aggregater

Question Posted / kish

Answer Posted / kish

Hi Krishna,

i think you r wrong...he is asking abt flat file...
by using LOOKUP we can eliminate duplicates...
You can eliminate duplicates and can capture that duplicates
using
dynamic lookup cache. look up the target table if New lookup
row=0 then it is unchanged (duplicate
record) SEND TO ONE TARGET

Is This Answer Correct ?    17 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between reusable transformation and mapplet.

1069

without table how to come first record only in oracle?

2234

Explain the features of connected and unconnected lookup.

918

What does command task mean?

1117

What is informatica powercenter repository?

1171

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.

2333

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10115

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1678

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2847

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2098

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

1147

What are data-driven sessions?

1182

What do you understand by term role-playing dimension?

1027

What is rank transform?

980

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

1017