Answer Posted / ahalya inturi
constraint based load order defines the order in which data
loads into the multiple targets based on primary key and
foreign key relationship.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Why union transformation is an active transformation?
How many number of sessions can one group in batches?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is rank transformation in informatica
How can we remove the duplicates from flat file source?
Please let me know how to make encryption and decryption with example?
How to elaborate powercenter integration service?
Tell me about Propagate functions in informatica
Suppose we do not group by on any ports of the aggregator what will be the output?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the different clients of powercenter?
Enlist the differences between database and data warehouse.
What if the source is a flat-file?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the components of workflow manager?