FAQs
Home · Centerprise · ReportMiner · EDIConnect · Data Virtualization

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

  • Is there a log file created that we can have written/saved to a folder of our choice for troubleshooting purposes? Something that shows when it ran, how many records it loaded, how many failed, and why?

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

  • What is a dataflow?

Workflow

  • What is a workflow?
  • What does deployment refer to in Centerprise?
  • What is the difference between a Decision and OR object in workflows?

Subflow

  • Is it possible to work with nested subflows in Astera Centerprise?

ReportMiner

  • What is the difference between Single Instance Data Region and Collection Data Region in Astera ReportMiner?

Miscellaneous

  • How can we preview ‘x’ number of records in a Data Preview window?
  • Does the Max result rows option in Tools > Options > Query tab being defaulted at 5000 limit the processing of any records?
  • What is Pushdown Mode?
FAQs
  • »
  • Search

© Copyright 2019, Astera Software