Search test library by skills or roles
⌘ K

Adaface Sample Informatica Questions

Here are some sample Informatica questions from our premium questions library (10273 non-googleable questions).

Skills

🧐 Question

Medium

Data sync task
Data Integration Connectors
Solve
Instakram uses Informatica for data integration. They want to use Informatica Salesforce Analytics Connector to connect between Data Integration and Salesforce Analytics. Instakram has  a data synchronization task that
            
            - Performs a lookup on the Salesforce Account object
            - Returns Salesforce lD and matches contacts to their correct Account records
            
            The task is running very slowly. What could be the possible reason for poor performance of the task and how can the speed of the task be increased?
 image

Medium

Fair Scheduler
Informatica BDM
Solve
You have a Hadoop cluster running with the fair Scheduler enabled. There are currently no jobs running on the cluster, and you submit a job A, so that only job A is running on the cluster. A while later, you submit Job B. Now Job A and Job B are running on the cluster at the same time. How will the Fair Scheduler handle these two jobs?
 image

Medium

Order keys and partition keys
Informatica BDM
Solve
You are the owner of a coffee and tea shop. You want to calculate the best-selling and second best-selling coffee and tea products.
The following table lists the products, the corresponding product categories, and the revenue from each product:
 image
In Informatica Windowing tab, you enter "Revenue (Descending)" as value for Order Keys and "Category" as value for Partition Keys. Which of the following represents the final result?
 image

Medium

Repository Service
PowerCenter
Solve
FTTX uses Informatica for their data integration services. Here are the details about the PowerCenter setup:
            
            - PowerCenter developer is the only PowerCenter client application running
            - There are two nodes in the domain
            - Node 1 is a gateway node, Node 2 is a worker node
            - PowerCenter Repository service is running on the worker node
            
            What happens when a user of FTTX connects to the PowerCenter Repository service for the first time?
 image
🧐 Question🔧 Skill

Medium

Data sync task
Data Integration Connectors

2 mins

Informatica
Solve

Medium

Fair Scheduler
Informatica BDM

2 mins

Informatica
Solve

Medium

Order keys and partition keys
Informatica BDM

20 mins

Informatica
Solve

Medium

Repository Service
PowerCenter

2 mins

Informatica
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Data sync task
Data Integration Connectors
Informatica
Medium2 mins
Solve
Fair Scheduler
Informatica BDM
Informatica
Medium2 mins
Solve
Order keys and partition keys
Informatica BDM
Informatica
Medium20 mins
Solve
Repository Service
PowerCenter
Informatica
Medium2 mins
Solve

Trusted by recruitment teams in enterprises globally

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte Microsoft NCS Doubtnut Sokrati J&T Express Capegemini

We evaluated several of their competitors and found Adaface to be the most compelling. Great library of questions that are designed to test for fit rather than memorization of algorithms.


Swayam Narain, CTO, Affable

hashtag image heart icon Swayam
customers across world
Join 1200+ companies in 75+ countries.
Try the most candidate friendly skills assessment tool today.
g2 badges
Ready to streamline your recruitment efforts with Adaface?
Ready to streamline your recruitment efforts with Adaface?
logo
40 min tests.
No trick questions.
Accurate shortlisting.
ada
Ada
● Online
Previous
Score: NA
Next
✖️