Answer Posted / rashmi garg
when we set the target load order, we create the groups,
each group may have multiple targets.
so data is loaded concurrently in all the targets of one
group and sequentially in different groups in the order.
Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How is union transformation utilized?
How can we create index after completion of load process?
What is depict expression change?
What are Dimensional table?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Define Pmrep command?
Briefly explain the aggregator transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How many ways a relational source definition can be updated and what are they?
What is dimensional table? Explain the different dimensions.
what is Active lock explain
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are active and passive transformations?
How to convert multiple rows to single row (multiple columns) in informatica