Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / usha
constraint based loading:-we need to enable the option in
session properties....
the main use of this optione is used to load the data if
the tables have PK and Fk relationship (or)which is used to
load the data if the tables having parent and chaild
realation .....
if we diidnt enable this option session will fail
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How we can create indexes after completing the loan process?
What is enterprise data warehousing?
What are pre and post-session shell commands?
What is the meaning of decode in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Make a note of the quantity vaults made in informatica?
Reusable transformation and shortcut differences
What is a joiner transformation and why it is an active one?
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
write a query to retrieve the latest records from the table sorted by version(scd)
Explain how many types of dimensions are available in informatica?
what is the complex transformation you used in informatica
To import the flat file definition into the designer where should the flat file be placed?
What is sq transformation?
