Frequently Asked Questions¶
Installation, Licensing, and Server Configuration¶
- What are the system requirements to install Astera Centerprise?
- Why do we need to make two installations for Astera Centerprise?
- What’s the difference between Custom and Complete installation?
- What’s the difference between 32-bit and 64-bit Centerprise?
- Can we use a single license for multiple users?
- Can we install Centerprise on more than one system using a single license key?
- Does Centerprise client work when it’s not connected to the server?
- Why do we need to build a cluster database and set up a repository while working with Centerprise?
- Which database providers does Centerprise support for setting up a cluster database?
- How many Centerprise clients can be connected to a single server?
- How do Centerprise client and server communicate?
- Is there any limit to the number of jobs that can be run on the server at a time?
- Can we access help documentation from Centerprise client?
- Up to how many servers can a single Centerprise client connect to?
Sources¶
- Does Astera Centerprise support data extraction from unstructured docs or text files?
- What is the difference between full and incremental loading in database sources?
- Does Centerprise support extraction of data residing in online sources?
- How is the File System Items Source used in a dataflow?
- How does the PDF Form Source differ from Report Source in Centerprise?
- Does Centerprise support extraction of data from EDI files?
- How does the Raw Text Filter option work in file sources in Centerprise?
Transformations¶
- What does the Aggregate Transformation do in Astera Centerprise?
- How is the Aggregate Transformation different from the Expression Transformation?
- What are the different sorting options in the Aggregate Transformation and how do they impact the output?
- Can we omit duplicate records using the Aggregate Transformation in Astera Centerprise?
- How many datasets can a single Aggregate object take input from?
- What is an Expression Transformation?
- How is Expression Transformation different from the Function Transformation?
- Does the SQL Query source support the use of parameters? If yes, how and in what cases can it be used?
- What is a set level transformation?
- What is a Record level transformation?
- What are the different types of lookups in Astera Centerprise?
- How is the Filter Transformation different from the Route Transformation?
- Is the Filter transformation similar to Data Quality Rules in function?
- What are the different types of Join available in Astera Centerprise?
- Can we perform a Join using more than one key in the Join transformation?
- What’s the difference between INSERT, UPDATE, UPSERT and DELETE actions available for data loading in a Database Table destination?
- What does the Truncate Table option do in Database Table destinations?
- What’s the difference between ‘Bulk insert with batch size’ and ‘Use single record insert’ Data Load Options in Database Table destinations?
- How does the Default Value column in Database Table destination layout work?
- What does the Advanced Connection Info option do in a Database object?
- What’s the maximum number of groups we can create in Route transformation?
- Can we perform a hierarchical join using the Join transformation in Centerprise?
Database Write Strategy¶
Dataflow¶