Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

IT Business Analytics10.10

Develop > Develop Content > Extend Content > IDE > IDE Advanced Tasks > Customize the Extraction Model and the EXT ETL Scripts

Customize the Extraction Model and the EXT ETL Scripts

The IDE generates ETL scripts that, by default, support deleting cases. You can change the default if you do not need to delete cases.

Modify the flag isDelete = 'Y' in the extraction model to isDelete = 'N', then DCS does not extract the delete flat file any more.

The extraction model is located under:

$HPBA_Home/ContentPacks/<CPname>/INBUILT/DATAMODEL/DATAINTEGRATION/EXTRACTION/
Remove the relevant SQL clause from the EXT ETL scripts.

Relevant SQL causes are all the SQL clauses with a table name that has the post-fix DEL_SRC.

The EXT ETL script is located under:

$HPBA_Home/ContentPacks/<CPname>/INBUILT/ETL/ENTITY_NAME/%NTEGRATION_ENTITY