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 |
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
What are the databases that informatica can connect to windows?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
what is the drillup & drill down?and use of the drill up and drill down?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
how to load only the first and last record of a flat file into the target?
What could be the possible resons of locks by user?
What are the main issues while working with flat files as source and as targets ?