Interview Questions Flashcards
Define Informatica Cloud?
Informatica Cloud is an ETL and Integration platform providing a web interface to the web developers to access administrator and monitor the tasks by using that web interface. It helps the developers build the solutions that perform the ETL processes between the cloud and on-site solution.
What is the primary purpose of the Informatica Cloud?
The primary purpose of the Informatica cloud is to resolve the data integration problem that takes place when we have to move the data from the legacy architecture to the cloud-based architecture. Through the Informatica cloud, we can resolve the issue of handling fragmented data inside and outside the firewall.
Explain the Runtime Environment?
The runtime environment is the implementation environment that implements the data integration tasks or application integration tasks. We should have a minimum of one environment setup for running the tasks in our organization. Generally, it is the server based on the data that gets arranged while processing. We can select either for processing through the Informatica servers or our local servers that remain behind our firewall.
What is a Replication Task?
The replication task enables us to replicate the data from the database table or the on-site application to the required target. We can replicate all the data sources rows that modify since the last runtime of the task through the inbuilt gradual processing method of the Replication task.
Differentiate Informatica PowerCenter and Informatica Cloud
The web version of Informatica PowerCenter is Informatica Cloud, and Informatica Cloud utilizes Informatica PowerCenter capabilities for providing web applications to all the functionalities. Informatica Cloud has the capability to provide more enhanced data integration capability over the cloud.
Explain Cloud Designer?
We can consider the Cloud designer as the equivalent version of the PowerCenter designer. Through cloud designer, we can effortlessly configure the mappings that are ideally the same as how we configure the PowerCenter mappings. Through Cloud designers, we can transform the data through the transformations like Filter transformation, Expression Transformation, etc.
Explain Synchronization Task?
The synchronization task allows us to synchronize the data between the source and the target. We can build a synchronization task from the IICS UI by choosing the original and the target without using any transformations like in mappings. We can also utilize expressions for transforming the data based on the business logic or use data filters for filtering the data. Without PowerCenter mapping and transformation, we can build the synchronization tasks like UI guides.
Differentiate Synchronization and Replication Task?
In the synchronization task, you should have an objective for data integration. But, a replication task will establish a target for you. The Replication task replicates a complete scheme and all the tables in it, which is impossible in the Synchronization task. A Replication task has an in-built incremental processing method. In the Synchronization task, we have to handle incremental data processing.
Explain Mapping Configuration Task?
Mapping Task or Mapping Configuration Task is similar to a session in the Informatica PowerCenter. We can define the parameters that relate to the mapping. Insert modern session properties for enhancing the performance and configuring the tasks to run on time.
Explain Hierarchical Schema in IICS?
Hierarchical Schema is an element where we can upload a JSON or an XML file that specifies the hierarchy of the output data. Hierarchy Parser transformation transforms the input according to the Hierarchical Schema that is related to the transformation.
Explain Dynamic Linking
Informatica Cloud enables us to establish a target file at runtime. We can use this feature only in mappings. In the target, we can select the “Create New at Runtime” option. We can choose a static filename that can be displaced with a new file whenever the mapping operates with the same name. We can also create a Dynamic filename such that whenever the mapping runs, we can create a file with the new name.
Explain Mapping areas of Cloud designers?
Explain Mapping areas of Cloud designers?
Explain Taskflow?
Task flow is similar to the workflow of the Informatica PowerCenter. Task flow regulates the execution order of the mapping configuration task or the synchronization task according to the previous task output.
Explain Informatica Cloud REST API?
Informatica Cloud REST API provides us with the capability to access the information through Informatica Intelligent Cloud Services. Developers also perform tasks like create, update, delete connections, starting and monitoring jobs, etc.
How do we read JSON source files in IICS?
Through the Hierarchy Parser transformation of IICS, we read the JSON files. We have to specify the hierarchy of the output data. Hierarchy parser transformation transforms the input according to the Hierarchical Schema that is related to the transformation.
