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 are the types of caches in lookup? Explain them.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
What is the Rank index port in Rank transformation?
how we load the data from source to staging area
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
What is rank transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
What is sql query override? When did u use sql query override?