What are main differences in Informatica PC 8.6 and 9.1
2.
What is the difference in primary key & unique key
3.
Explain facts & dimension tables
4.
What is the difference in a datamart & a datawarehouse
5.
From an EMP table which has attributes - EMP_ID,EMP_NAME,DEPT_ID, how will you find those department that have more than 100 employees. Please write SQL query with correct syntax.
6.
In employee table which has attributes EMP_ID,EMP_NAME,DEPT_ID, how will you update the EMP_NAME as 'DUMMY' for all employees from DEP_ID=100. Write the query with correct syntax.
7.
What is difference in Lookup & joiner transformation
8.
Write the query for - Selecting the unique employee names from employee table which has attributes emp_id,emp_name_dept_id
9.
What is indirect Loading of flat file
10.
We can extract data from heterogeneous sources using Informatica PowerCenter
A.
True
B.
False
Correct Answer A. True
Explanation We can use heterogeneous sources & extract data from them using INFA PC. This is not possible using only SQL/PLSQL scripts in database. In all such scenarios, we can use ETL instead of database SQLs
Rate this question:
11.
How many columns can be returned by using Un-connected lookups
A.
More then 1
B.
Only 1
Correct Answer B. Only 1
Explanation For more details - http://www.dwbiconcepts.com/tutorial/24-interview-questions/11-top-50-informatica-interview-questions-with-answers.html
Rate this question:
12.
In UNIX, we can use _____ command to change file permissions
Correct Answer chmod
Explanation Please go through all basic commands, a list of all basic commands are present at -
http://thetechtrainer.wordpress.com/2013/03/13/unix-basic-commands-list/
Rate this question:
13.
Which of the below option is correct in case of Static Cache in lookup
A.
Cache does not get modified once it is built
B.
Cache gets modified only if source data has modified records
C.
Cache gets modified within the session run
D.
Cache is not built at all
Correct Answer A. Cache does not get modified once it is built
Explanation To understand in details about Dynamic & Static cache, read the below article - http://www.dwbiconcepts.com/etl/14-etl-informatica/16-dynamic-lookup-cache.html
Rate this question:
14.
If you want to find the top 5 customers that have spent most per month for buying a product - 'PROD123' , what will be the dimensions required.
A.
Customers
B.
Products
C.
Location
D.
Date(Month)
Correct Answer(s) A. Customers B. Products D. Date(Month)
15.
In SCD3, complete history is maintained
A.
True
B.
False
Correct Answer B. False
Explanation in SCD 3, we create two extra columns, one to hold old data, and the other to hold new data. So only the latest two entries can be stored. Complete history is maintained only in SCD2
Rate this question:
16.
As per Bill Inmon, datawarehouse is defined as
A.
Subject Oriented
B.
Integrated
C.
Time Variant
D.
Non Volatile
Correct Answer(s) A. Subject Oriented B. Integrated C. Time Variant D. Non Volatile
Explanation Please go through the meaning of all these definitions & how are they actually implemented in DW
http://www.1keydata.com/datawarehousing/data-warehouse-definition.html
Rate this question:
17.
Select * from dual gives you following
A.
NULL
B.
X
C.
Dummy
D.
NA
Correct Answer B. X
18.
In UNIX, if you want find the number of lines containing word 'hello' in file hello_world, which command will you use
A.
Find hello hello_world
B.
Cut hello hello_world
C.
Grep -c hello hello_world
D.
Grep hello hello_world | wc -c
Correct Answer C. Grep -c hello hello_world
19.
Which of the following is not an ETL tool
A.
Datastage
B.
Ab-Initio
C.
SSIS
D.
BO
Correct Answer D. BO
Explanation BO (Business Objects is a reporting tool). SSIS is ETL tool by Microsoft, its full form is Sql Server Integration Services
http://www.etltool.com/list-of-etl-tools/
Rate this question:
20.
Select all correct answers - Surrogate Key is
A.
Unique Key
B.
Can be used as substitute to Natural Key
C.
Is controlled by source systems
D.
Can be generated using INFA sequence genrator
Correct Answer(s) A. Unique Key B. Can be used as substitute to Natural Key D. Can be generated using INFA sequence genrator
Explanation Surrogate is controlled by the DW & not by the source system
Rate this question:
21.
Mapplet is a _____________ component
Correct Answer(s) Reusable re-usable
22.
Select all that are correct - Which of the following is type of task in Workflow
A.
Session
B.
Email
C.
Command
D.
Event Wait
Correct Answer(s) A. Session B. Email C. Command D. Event Wait
23.
Aggregator transformation is Active transformation
A.
True
B.
False
Correct Answer A. True
Explanation Number rows can change in output as we do group by and perform aggregation
Rate this question:
24.
Which of the following can be used to create multiple rows using single input row
A.
Java Transformation
B.
Normalizer
C.
Aggregator
D.
Router
Correct Answer(s) A. Java Transformation B. Normalizer
25.
Sorter transformation if Passive transformation
A.
True
B.
False
Correct Answer B. False
Explanation We can check the property - select distinct; this make sorted Active transformation
Rate this question:
26.
Following command is used to execute Informatica workflow from UNIX
A.
Pmrep
B.
Pmcmd
Correct Answer B. Pmcmd
Explanation pmrep is used for repository level operations like export/import workflow, pmcmd is used to run/stop the workflow
Rate this question:
27.
SQL override option in Source Qualifier can be used if the source is a Flat File
A.
True
B.
False
Correct Answer B. False
Explanation Override can be used if source is Relational DB
Rate this question:
28.
Which of the following is in-correct for Truncate command in oracle
A.
Deletes all records from table
B.
Commit command is required after truncate command
C.
Along with all records it deleted the table schema also
D.
Can be used to delete only few records based on filter condition
Correct Answer(s) B. Commit command is required after truncate command C. Along with all records it deleted the table schema also D. Can be used to delete only few records based on filter condition
Which of following is valid informatica partitioning type
A.
Key Range
B.
Hash
C.
Round Robin
D.
Mod
Correct Answer(s) A. Key Range B. Hash C. Round Robin
Explanation You should know basic concepts & different types of partitioning
http://www.dwbiconcepts.com/etl/14-etl-informatica/12-implementing-informatica-partitions.html
Rate this question:
39.
While reading a flat file in informatica we can skip the header record
A.
True
B.
False
Correct Answer A. True
Explanation We have a option to skip number of records -
http://www.dwbiconcepts.com/etl/14-etl-informatica/155-loading-flatfiles-delimited-by-comma-and-double-quotes.html
Rate this question:
40.
Workflow along with session, mapping, transformations, sources & targets can be exported from
A.
Workflow Manger
B.
Workflow Monitor
C.
Designer
D.
Repository Manager
Correct Answer D. Repository Manager
41.
If Integration service is down we can still login to Informatica Repository
A.
True
B.
False
Correct Answer A. True
Explanation Integration service is responsible for executing the workflow; Repository service is required for repository related operations
Rate this question:
42.
Which of the following are correct for Source Qualifier
A.
Can read data from flat files as well as DB
B.
Converts source data types to native powercenter datatypes
C.
Is active transformation
D.
Can perform joins for DB source
Correct Answer(s) A. Can read data from flat files as well as DB B. Converts source data types to native powercenter datatypes C. Is active transformation D. Can perform joins for DB source