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 |
What is a sequence generator transformation?
Can anyone please distinguish what is Inner join and Outer join
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
What is the main difference between a Joiner Transformation and Union Transformation?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What is informatica etl tool?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
What is confirmed dimension and fact?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?