A. Operating system management
B. Data integration and ETL processes
C. Web application development
D. Database design<\/p>\n\n\n\n
A. Extract, Transform, Load
B. Evaluate, Test, Launch
C. Encode, Transfer, Link
D. Extract, Transfer, Link<\/p>\n\n\n\n
A. Workflow Manager
B. Repository Manager
C. Mapping Designer
D. Workflow Monitor<\/p>\n\n\n\n
A. A data storage location
B. A process that modifies or filters data
C. A source connection
D. A database index<\/p>\n\n\n\n
A. Filter Transformation
B. Router Transformation
C. Expression Transformation
D. Sorter Transformation<\/p>\n\n\n\n
A. To sort data
B. To validate data
C. To retrieve related data from a table or cache
D. To delete unwanted data<\/p>\n\n\n\n
A. To monitor data loading
B. To design ETL mappings
C. To create and manage sessions, workflows, and tasks
D. To generate reports<\/p>\n\n\n\n
A. It runs SQL queries
B. It manages objects in the Informatica repository
C. It loads data into the target
D. It stores only session logs<\/p>\n\n\n\n
A. Router Transformation
B. Expression Transformation
C. Aggregator Transformation
D. Lookup Transformation<\/p>\n\n\n\n
A. To join multiple sources
B. To calculate aggregate functions like SUM or AVG
C. To sort records alphabetically
D. To perform data validation<\/p>\n\n\n\n
A. Rank Transformation
B. Router Transformation
C. Filter Transformation
D. Sequence Generator<\/p>\n\n\n\n
A. It filters target data
B. It defines how Informatica reads data from a source
C. It performs data validation
D. It generates surrogate keys<\/p>\n\n\n\n
A. To merge multiple files
B. To combine data from two sources based on a condition
C. To rank rows
D. To split data<\/p>\n\n\n\n
A. Router Transformation
B. Sorter Transformation
C. Rank Transformation
D. Filter Transformation<\/p>\n\n\n\n
A. Static Cache
B. Dynamic Cache
C. Persistent Cache
D. Reusable Cache<\/p>\n\n\n\n
A. A connection between mappings and workflows
B. A database connection file
C. A debugging tool
D. A log viewer<\/p>\n\n\n\n
A. Source file
B. Target file
C. Repository database
D. XML file<\/p>\n\n\n\n
A. Expression Transformation
B. Sequence Generator Transformation
C. Rank Transformation
D. Filter Transformation<\/p>\n\n\n\n
A. A transformation used only once
B. A transformation that can be shared across multiple mappings
C. A transformation with no input ports
D. A transformation used for reports<\/p>\n\n\n\n
A. Workflow Designer
B. Repository Manager
C. Workflow Monitor
D. Mapping Designer<\/p>\n\n\n\n
1. What is Informatica primarily used for? A. Operating system managementB. Data integration and ETL processesC. Web application developmentD. Database design Answer: B 2. What does ETL stand for in Informatica? A. Extract, Transform, LoadB. Evaluate, Test, LaunchC. Encode, Transfer, LinkD. Extract, Transfer, Link Answer: A 3. Which Informatica component is used to create mappings […]<\/p>\n","protected":false},"author":1,"featured_media":7567,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62],"tags":[63,64,65,66],"class_list":["post-1200","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-informatica-skill-test","tag-informatica","tag-informatica-online-test","tag-informatica-quiz","tag-informatica-skill-test"],"_links":{"self":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/posts\/1200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/comments?post=1200"}],"version-history":[{"count":2,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/posts\/1200\/revisions"}],"predecessor-version":[{"id":31177,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/posts\/1200\/revisions\/31177"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/media\/7567"}],"wp:attachment":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/media?parent=1200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/categories?post=1200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/tags?post=1200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}