Interested to Buy Any Domain ? << Click Here >> for more details...
what is constraint based loading
- 2 Answers
- 6551 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is tracing level and what are the types of tracing level?
How to differentiate between the active and passive transformations?
What are Dimensions and various types of Dimensions?
How to join three sources using joiner? Explain though mapping flow.
How can you run a session without using server manager?
what is the difference between Informatica7.1 & informatica 8.1
Can we get 1st record through Informatica(without sequence number).
In informatica workflow manager, how many repositories can be created?
What is parallel processing in informatica?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
Teradata 
