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 |
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
what is normalization? explain 1st NF, 2nd NF, 3rd NF
What is the reusable transformation?
What are the different tools in workflow manager?
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
without matching columns in two tables. how can you join
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
Describe an informatica powercenter?