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?
- Why Centerprise is possibly not able to access my source file or create a new one?
- Will an upgrade result in the failure of existing .dlls?
- I uninstalled Centerprise from one machine and attempted to activate it on a new device, but the server is not accepting my license key. Why am I getting this error?
- Will I lose all my scheduled jobs when upgrading to the latest version?
- Is there a way to export the existing jobs from the previous to the latest version of Centerprise?
- Is there a permanent link from where I can always have access to the newest build?
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?
- What is the outcome if an incoming record matches multiple rules in Route transformation?
- Can we perform a hierarchical join using the Join transformation in Centerprise?
- What is the meaning of Batch Size in Sequence Generator transformation where a sequence is generated in a Database Table?
- Can we join multiple children to a single parent node using only one Tree Join transformation object?
- Which output would be assigned if a record satisfies two conditions in a Switch transformation object?
- What is the order of priority of options in different columns in the Layout Builder of the Merge transformation object?
- What is the difference between Survivor Type and Precedence in Merge transformation?
- Why does the Return All option on the Lookup Options screen in the File Lookup transformation give an error?
Destinations¶
- If I want to have a different field delimiter, say a pipe (“|”), is there an option to export with another delimiter and filename extension?
- I want to change the output format of a column, say integer to string, or vice versa. Any error trapping abilities with that conversion?
- Tools Menu > Data Format has different date formats, but it doesn’t seem to do anything. Each time I go into it, it still has the first option selected even after choosing a different one.
- Can we export the Object Path column present in the Data Preview window?
- What will be the outcome if we write files multiple times to the same Excel Destination?
Data Profiling¶
Database Write Strategy¶
- Why Database Diff Processor does not have an output node in Centerprise v8.2?
- Which Database Write Strategy is more efficient for working with larger volumes of data?
- In which Database Write Strategy do we use a CDC file?
- How can CDC improve the performance of Database Diff Processor when used in conjunction?
- Which one from the Database Diff Processor and Source Diff Processor is a more cost-effective write strategy?
- Is it necessary for the database tables to be of same layout in order to work with Data Driven, Database Diff Processor, and Source Diff Processor?
- Is there any limitation to the type of source each Database Write Strategy can take input from?
- Why is it necessary to select the Single Port option in the Database Table Destination while working with a write strategy?
- Will a record be tried against the following rule if it satisfies the current rule in Data Driven write strategy?
- What is the difference between ‘Single Output’ and ‘One Port for Each Action’ in Source Diff Processor?
- What is the difference between UPSERT and Database Diff Processor?
- Is it sufficient to use a Slowly Changing Dimension Write Strategy to insert new records and update existing records? Or do we need to use it in conjunction with Database Diff Processor for the purpose?
- How can Source Diff Processor load data incrementally?
Dataflow¶
Workflow¶
ReportMiner¶