Answer Posted / reni g
With a test load, the Integration Service reads and
transforms data without writing to targets. To configure a
session to perform a test load, enable test load in session
properties and enter the number of rows to test.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the use lookup tables and Aggregate tables?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
how do u really know that paging to disk is happening while u are using a lookup transform?
Can u access a repository created in previous version of Informatica?
what is a worklet?
how do u really know that paging to disk is happening while u are using a lookup transform?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
how do u set partition points in the mapping?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is data cleaning?
What is a mapping, session, worklet, workflow, mapplet?
can cubes contain measures ?
Explain the key challenges that you face while performing etl testing.
what is the meaning of upgradation of Repository?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?