|
Question |
Rating |
View Answer |
|
Can we override a native sql query within Informatica? Where do we do it? How do we do it? |
|
View Answer |
|
How do we call shell scripts from informatica? |
|
View Answer |
|
What is the difference between Power Center & Power Mart? |
|
View Answer |
|
How to determine what records to extract? |
|
View Answer |
|
How can we use mapping variables in Informatica? Where do we use them? |
|
View Answer |
|
What is Full load & Incremental or Refresh load?
|
|
View Answer |
|
What is the metadata extension?
|
|
View Answer |
|
Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values) |
|
View Answer |
|
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA.
|
|
View Answer |
|
What are the modules in Power Mart? |
|
View Answer |
|
What is Full load & Incremental or Refresh load? |
|
View Answer |
|
What are active transformation / Passive transformations? |
|
View Answer |
|
Do we need an ETL tool? When do we go for the tools in the market? |
|
View Answer |
|
if a flat file cotains 1000 records how can i get first and last records only? |
|
View Answer |
|
What are parameter files ? Where do we use them? |
|
View Answer |
|
What is a three tier data warehouse? |
|
View Answer |
|
Can Informatica load heterogeneous targets from heterogeneous sources? |
|
View Answer |
|
What are the different versions of Informatica?
|
|
View Answer |
|
What is ETL? |
|
View Answer |
|
What is a mapping, session, worklet, workflow, mapplet? |
|
View Answer |