|
Question |
Rating |
View Answer |
|
Compare ETL & Manual development? |
|
View Answer |
|
When do we Analyze the tables? How do we do it? |
|
View Answer |
|
What is partitioning? What are the types of partitioning? |
|
View Answer |
|
What are snapshots? What are materialized views & where do we use them? What is a materialized view log? |
|
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 is Full load & Incremental or Refresh load? |
|
View Answer |
|
How to determine what records to extract? |
|
View Answer |
|
How do we extract SAP data Using Informatica? What is ABAP? What are IDOCS? |
|
View Answer |
|
Do we need an ETL tool? When do we go for the tools in the market? |
|
View Answer |
|
Can we use procedural logic inside Infromatica? If yes how , if now how can we use external procedural logic in informatica? |
|
View Answer |
|
Can we override a native sql query within Informatica? Where do we do it? How do we do it? |
|
View Answer |
|
What are parameter files ? Where do we use them? |
|
View Answer |
|
How can we use mapping variables in Informatica? Where do we use them? |
|
View Answer |
|
What is a mapping, session, worklet, workflow, mapplet? |
|
View Answer |
|
What is Informatica Metadata and where is it stored? |
|
View Answer |
|
How do we call shell scripts from informatica? |
|
View Answer |
|
Can Informatica load heterogeneous targets from heterogeneous sources? |
|
View Answer |
|
What are the different Lookup methods used in Informatica? |
|
View Answer |
|
What are active transformation / Passive transformations? |
|
View Answer |
|
What are the modules in Power Mart? |
|
View Answer |