What is Test load plan? Let us assume 10 records in source,
how many rows will be loaded into target?
Answers were Sorted based on User's Feedback
Answer / babu
NO rows will be loaded in to the target,bcoz this only
TESTING
Is This Answer Correct ? | 9 Yes | 4 No |
Enable Test Load : You can select this option to allow only a few records to
pass through the mapping. This option is useful when
you are in the testing phase of your project.
Number of rows to test : When you select the Enable Test Load option, you
can define the number of records you wish to flow
from Mapping. Suppose you have 10,000 records to
process. You can check the Enable Test Load option
and mention the number of records you wish to test. So,
if you define 100 records, Informatica will only process
100 records out of the 10,000 records.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chiru
Source records should be load into the target .That is the
load plan
Is This Answer Correct ? | 1 Yes | 11 No |
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
what is the difference between onsite & client site?
According to his methodology what all you need before you build a datawarehouse
What is Datadriven?
in realtime which situations u can use unconnected lookup transformation
How an expression transformation differs from aggregator transformation?
What is the command used to run a batch?
How we can create indexes after completing the loan process?
permutations of mapplet
why do u use shortcuts in informatica.?
Explain informatica architecture - version 8 / 9
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.