| Other Informatica Interview Questions |
|| Asked @
|In Which scenario did u used Incremental loading?
|If i have one source having 10 ports.In a mapping i use that
source one target having that ten ports.Data from 5 ports
are going to target through a mapplet and another 5 ports
are going to target through another mapplet.Both 2 mapplets
are intially passive in nature.But presently my requirment
to convert on mapplet to ACtive.How can i do it.
|what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
|Two workflows are running at same time first workflow is
succeeded but second workflow is failed but there is no
|What is the capacity of power cube?
|i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
|how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
|If u select groupby port in aggregator what is output and
dont select groupby option what is output
|What are the different threads in DTM process?
|How will you update the first four rows and insert next
four rows in a mapping?
|If I have set the property Treat Source Rows as Insert and
for the target properties I have checked the boxes Update as
Update, what will happen to incoming rows?
What exactly is the use of these check boxes and in which
scenarios we use them. Also what is the sequence in which
informatica understands these properties.Does it takes
whatever is defined in treat source rows as property or it
is in any other way. Please explain.
|what is shared lookup&persistent lookup?
|For more Informatica Interview Questions Click Here |