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

Others

Embedded Systems Agile/Scrum Cyber Security SAP ABAP SAP HANA SAP Fiori SAP GRC SAP QM SAP SuccessFactors Salesforce Developer Salesforce Administrator Boomi Dynamics 365 SCM Dynamics 365 Finance Dynamics 365 Customer Service Dynamics 365 Sales Dynamics 365 Customer Voice Dynamics 365 Commerce Dynamics AX Spark Adobe InDesign Oracle Hyperion Planning Customer Support ITIL Blue Prism SAS SCCM SSAS SSIS SSRS Citrix Google AdWords Weblogic Talend UML Human Resource Management Talent Acquisition Power Apps RPA CISCO CISCO DCIM French Apache NiFi Apache Pig TIBCO Spotfire TIBCO Business Studio TIBCO Administration TIBCO ActiveMatrix BPM TIBCO Hawk TIBCO Apache Tomcat Oracle Hyperion Financial Management Oracle Fusion Oracle AIA Oracle APEX Oracle BPM Oracle Apps Oracle Financial Apps Oracle OAF Oracle SOA SAP Hybris SAP BusinessObjects SAP BI SAP PowerDesigner SAP PowerBuilder SAP Leonardo SAP MDM SAP MDG SAP BW SAP SRM SAP UI5 SAP MM SAP HCM SAP BTP (SCP) SAP PI SAP PP SAP Basis SAP SD SAP WM SAP PS SAP BODS SAP DBM SAP Litmos SAP FICO Loadrunner WPF WebFOCUS Ranorex Informatica Data Quality GDPR RabbitMQ Gradle Grunt EJB SnapLogic SharePoint Progress (OpenEdge) Informatica B2B Data Exchange Informatica MDM Joomla Ionic Liferay Sqoop Computer Literacy Communication Skills Technical Support Ecommerce Analytics Software Support Growth Marketing Marketing Analysis Digital Marketing Product Marketing SEO Outreach Market Research Jira German Italian Spanish Grammar & Vocabulary Listening Comprehension Reading Comprehension Sentence Structure
🧐 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 1500+ companies in 80+ 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
✖️