Tekafe

Typically you will want your field to be either indexed or stored or both. If you set both to false, that field will not be available in your Solr docs (either for searching or for displaying). See Alexandre's answer for the special cases when you will want to set both to false. As stated   here   :   indexed=true   makes a field searchable (and sortable and facetable). For eg, if you have a field named   title with   indexed=true , then you can search it like   q=tite:test , where test is the value you are searching for. If   indexed=false   for field   title then that query will return no results, even if you have a document in Solr with   title 's value being test . stored=true   means you can retrieve the field when you search. If you want to explicitly retrieve the value of a field in your query, you will use the   fl   param in your query like   fl=title (Default is   fl=*   meaning ret...

1. How do you remove Duplicate records in Informatica? And how many ways are there to do it? There are several ways to remove duplicates. If the source is DBMS, you can use the property in Source Qualifier to select the distinct records. Or you can also use the SQL Override to perform the same. You can use, Aggregator and select all the ports as key to get the distinct values. After you pass all the required ports to the Aggregator, select all those ports , those you need to select for de-duplication. If you want to find the duplicates based on the entire columns, select all the ports as group by key. The Mapping will look like this. You can use Sorter and use the Sort Distinct Property to get the distinct values. Configure the sorter in the following way to enable this. You can use, Expression and Filter transformation, to identify and remove duplicate if your data is sorted. If your data is not sorted, then, you may first use a sorter to sort the data and then ...