Informatica MCQs ( Multiple Choice Questions ) with Answers
Set IV
Q1. Data scrubbing is which of the following ?
a) A process to reject data from the data warehouse and to create the necessary indexes
b) A process to load the data in the data warehouse and to create the necessary indexes
c) A process to upgrade the quality of data after it is moved into a data warehouse
d) A process to upgrade the quality of data before it is moved into a data warehouse
Answer is d) A process to upgrade the quality of data before it is moved into a data warehouse
Explanation : For explanation Join the discussion below
Q2. Which database does not support user-defined return values?
a) Sybase
b) Oracle
c) Informix
d) SQL Server
Answer is c) Informix
Explanation : For explanation Join the discussion below
Q3. What is cache?
a) An area in Target database
b) An area in Repository Server
c) An area in Informatica Server
d) An area in Memory
Answer is d) An area in Memory
Explanation : For explanation Join the discussion below
Q4. Which of the following are join types are there in
informatica?
i) Normal
ii) Master Outer
iii) Left Outer
iv) Exclusive Outer
v) Right outer
a) i and ii
b v and iv
c) iii and ii
d) v, iv and i
Answer is a) i and ii
Explanation : For explanation Join the discussion below
Q5. In ASCI I mode for each character, how many bytes are required.
a) 1 byte
b) 2 bytes
c) 3 bytes
d) 4 bytes
Answer is a) 1 byte
Explanation : For explanation Join the discussion below
Q6. Comparing with Informatica power center 5.1 and 6.1 version, in 6.1 version, which transformations have been newly added?
a) Lookup & Union
b) Sorter and sequence
c) Transaction control & Sorter
d) Sorter & Union
Answer is c) Transaction control & Sorter
Explanation : For explanation Join the discussion below
Q7. XML stands for
a) Extended Mainframe Language
b) Extended Markup language
c) Enhanced Mainframe Language
d) Enhanced Markup Language
Answer is b) Extended Markup language
Explanation : For explanation Join the discussion below
Q8. Which types of data movement modes does Informatica
server supports?
i) ASCII
ii) Unicode
iii) Binary
iv) Decimal
v) Hexadecimal
a) i and iii
b) ii and v
c) iii and ii
d) i and ii
Answer is d) i and ii
Explanation : For explanation Join the discussion below
Q9. Which one of these are not terminologies related to
Informatica
i) Drill down
ii) Dimension
iii) Session
iv) Mapping
v) Workflow
a) ii and iii
b) ii, iii, iv and v
c) i and ii
d) iii and iv
Answer is b) ii, iii, iv and v
Explanation : For explanation Join the discussion below
Q10. In what version of Informatica FlatFile Lookup Is available.
a) Infa 5
b) Infa 6
c) Infa 7
d) All The Above
Answer is c) Infa 7
Explanation : For explanation Join the discussion below
Q11. What are the types of extractions available?
i) Full Extraction
ii) Progressive Extraction
iii)Incremental Extraction
iv)Big Bang Extraction
v)Slow Extraction
a) i and ii
b) i and iii
c) ii and iv
d) v and iii
Answer is b) i and iii
Explanation : For explanation Join the discussion below
Q12. Where is the Source and Target information stored?
a) Repository Server
b) Informatica Server
c) Specific Folder
d) Repository Database
Answer is d) Repository Database
Explanation : For explanation Join the discussion below
Q13. Informatica server holds two different values for a mapping Variable. What are they called as?
a) Start value/End value
b) Start Value/Current Value
c) Start Value/Persistent Value
d) Start Value/Active Value
Answer is b) Start Value/Current Value
Explanation : For explanation Join the discussion below
Q14. Where will the Informatica server store data until it completes Aggregate calculations?
a) Memory
b) Repository Server Cache
c) Database
d) Cache
Answer is c) Database
Explanation : For explanation Join the discussion below
Q15. Characters in the parameter file must be a subset of
a) Repository server code page
b) Information Server code page
c) Repository agent code page
d) Informatica client code page
Answer is b) Information Server code page
Explanation : For explanation Join the discussion below
Recommended MCQs
Informatica MCQs with Answers Set I
Informatica MCQs with Answers Set II
Informatica MCQs with Answers Set III
Informatica MCQs with Answers Set V
Informatica MCQs with Answers Set VI
Java MCQs with Answers Set III
Computer Organisation and Architecture MCQs with Answers Set I
Computer Organisation and Architecture MCQs with Answers Set II
Computer Organisation and Architecture MCQs with Answers Set III
If you have any doubts join the discussion below ,our Moderator will reply to your Queries
