Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
Instead of starting from scratch, you can use an existing query to create more queries. You can either select or open an existing query, and then save the it as a new query.
In the
Saved Queries
panel, select the query that you want to save as a new query.
Click
Actions
Save As
.
The
Save As
dialog box appears.
Enter a unique name and description for the query.
Optionally, enable any of the following query options:
Set as my default. The query becomes the default query.
Share with all. The query is shared with other users.
Click
Save
.
A copy of the query is saved with the new name, and the query opens.
Optionally, modify the new query.
Click
Actions
Edit
.
Edit the query as required.
You can make the following changes to the query:
Add fields.
Remove fields.
Enable the query to be case-sensitive.
Select a field name by which the query result must be sorted.