Jun

Informatica Interview Questions
- Monika Jacob
- 14th Jun, 2022
- 440 Followers
Informatica Interview Questions
Informatica: Introduction
Informatica is actually a power center. It is widely used as an information, extraction, transformation, and loading tool. It is further used to build an enterprise data warehouse. The components, which are located within Informatica help in extracting data from its sources and further using it for business requirements. But in order to use the data for business requirements, you need to convert it first. And finally, the data is loaded onto a target data warehouse.
Informatica: Career Prospects
Informatica has got the widespread ability in terms of efficient data processing, data partitioning, and bulk extraction. This altogether contributes to the maximum quality work at any large-scale organization. Almost maximum of business domains utilize Informatica tools and thus career prospects are endless in the field of Informatica. But in order to land a good job in Informatica, you need to successfully crack Informatica interview questions.
Cracking Informatica Interview Questions
Cracking Informatica interview questions is not exactly rocket science. No doubt since the web world is rapidly evolving, there are more and more challenges in the Informatica field. And you need to understand that you will not be ever able to know it all. What you need to do is brush up on your foundation. Try to know and understand your basics. Clear up the basic know-how of Informatica and this will help you to get an upper hand in the Informatica interview. Also, be open and honest about what you know and what you don’t know. This will give a clear picture of the mind of the interviewers. But you must display a learning attitude. Make sure that you always tell the interviewer that you are willing to learn new things and incorporate new skills which will further help you in your personal and professional growth.
Following is the list of some Informatica Interview Questions and their answers.
Informatica Interview Questions
1) In warehouses how many schemas are there?
- Star Schema
- Snow Flake Schema
- Galaxy Schema
- Fact Constellation Schema
2) Could you explain what is Enterprise data warehouse?
3) What is different between the data warehouse and data mart?
A Data warehouse is a collection of multiple functional areas.it is the central unit which is made by combining all the data marts
4) How to Delete duplicate row using Informatica?
- Using Source Qualifier, under properties tab select Distinct
- Using Sorter, under properties tab select distinct
First one is the better option when the source is relational but when a source is a file then you need to use the second option only.
5) How can we handle two sessions in Informatica?
- Sequential batches: sequential batches session runs one by one
- Concurrent batch: concurrent batches session runs at the same time
6) Do you find any difficulty while working with flat files as source and target?
Yes, there are difficulties I found while working with flat files some of them are:
- We can’t use SQL override in flat files instead of that we have to use transformations.
- testing the flat files is a very uninteresting job
- We need to specify the correct path in the session and mention whether that file is ‘direct’ or ‘indirect. Keep that file in the exact path which we have specified in the session and we have to keep the file in the exact path as mentioned in the session.
- If we miss the link to any column of the target, then all the data will be placed in the wrong fields. That missed column won’t exist in the target data file.
7) What is the meaning of Decode in Informatica?
Decode is a special function that searches a port for the specified value. It is a better option to use DECODE function when the number of conditions is large because it is less costly compared to the IF function. and it can use in a select statement whereas we can not use IIF Function In select Statement.
8) What do think which one is the better joiner or look up?
9) What is Domain in terms of Informatica?
10) What is a Mapplet/worklet in Informatica?
11) Describe an Informatica PowerCenter?
12) What is the cumulative sum and moving sum?
moving sum returns the sum of a specifies set of rows. It ignores null values when calculating the moving sum so that if all values are NULL, Then the function Returns NULL
MONINGSUM(ROWNAME,Rowsetvalue)
13) Explain sessions and how many types of sessions are there?
There are two type of sessions in Informatica
- Reusable Sessions
- Non-Reusable Sessions
14) Explain what transformation and how many are there in Informatica?
- Active
- Passive
- connected,
- unconnected
15) What is a surrogate key?
16) What is PMCMD COMMAND?
- Scheduling a workflow
- Start or stop workflow
- Start workflow from a task
- Stopping / Aborting specific task
- Aborting workflow
17) Is STOP AND ABORT are same IN INFORMATICA?
Stop will Stop reading from the source and release the memory blocks that are occupied by the session at a time but it will continue updating and committing changes in target whereas abort also stop reading but it has the timeout period of 60 sec. If the session fails to update or commit the changes within 60 sec then the session will be aborted by terminating the DTM process thread and it will not release the memory immediately.
To ensure Data Consistency Stop Will try to Rollback data but in Abort kill the process immediately so that can’t be rolled back.
18) What are batches?
There are two types of batches are theirs.
batch run session one after another is called Sequential batch and batch which run a session at the same is concurrent.
19) Can you generate sequence numbers without using the sequence generator transformation?
20) What are the static cache and dynamic cache in Informatica?
In dynamic caches, cache memory will refresh as soon as the record is inserted or updated in the look-up table.
21) What is the need of ETL tools?
22) What is the fact table?
23) What is polling?
24) How many dimensions are there in Informatica?
- Conformed Dimension
- Degenerated Dimension
- Role-playing dimension
- Junk Dimension
25) How Can u generate reports in Informatica?
26) What is the Rank index port in Rank transformation?
27) What is the target load order?
28) What is data transformation manager Process?
29) How to generate sequence numbers?
30) Which transformation is needed while using the Cobol sources as source definitions?
31) What are active and passive transformations?
32) In how many ways we can create ports?
33) What is Data Caches/ Index Caches?
34) What do you mean by blocking transformation?
35) What you know about transaction control transformation?
36) How do you change a non-reusable transformation to reusable transformation?
37) What is active transformation in Informatica?
Informatica transformations are repository entities that can read, change or pass data to the defined target structures like tables, files, or any other structures required. Active transformations are those which alters the data rows and the number of input rows passed to them.
Aggregator, filter, joiner, normalizer, etc. are a few examples of active transformation in Informatica. An active transformation can perform any actions; change the number of rows that passes through the transformation, change the transaction boundary, change the row type attribute.
Leave A Comment :
Valid name is required.
Valid name is required.
Valid email id is required.