Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is constraint based loading

Question Posted / bharathi

Answers were Sorted based on User's Feedback



what is constraint based loading..

Answer / chandrasekar

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

what is constraint based loading..

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

Post New Answer

More Informatica Interview Questions

can we use self join in informaitca?

3 Answers   IBM,

can you use flat file for repository?why?

2 Answers   TCS,

How to use pmcmd utility command?

0 Answers  

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

What are the different tools in workflow manager?

1 Answers  

what is target update override and when we use it?

2 Answers   TCS,

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

What is a joiner transformation?

0 Answers  

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories