Answer Posted / pawan
Test Load is an option at session level.Enabling this option provides an option for debugging & dry run of informatica codes without any (impacts) commit in target tables. Number of rows for dry run/testing can also be specified .By default its 1.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to create the source and target database connections in server manager?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the use of code page?
In how many ways we can create ports?
What is rank index in rank transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Enlist the various types of transformations.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain in detail about scd type 1 through mapping.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What the difference is between a database, a data warehouse and a data mart?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are multi-group transformations?
Briefly explain the aggregator transformation?