what is constraint based loading
Answers were Sorted based on User's Feedback
Constraint based load order defines the order of loading the
data into the multiple targets based on primary and foreign
keys constraints.
If i wrong means please send mail to chandranmca2007@gmail.com
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
what is the use of Data Mart?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
Slowly changing dimensions, types and where will you use them
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
HOW DO YOU CONNECT TO REMOTE SERVER ?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
Where should yoU place the flat file to import the flat file defintion to the designer?
How to load time dimension?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
What are the restrictions of union transformation?
Differentiate between source qualifier and filter transformation?