ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
what is the diff b/w target load plan and cbl?
 Question Submitted By :: Narasimha.inf
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the diff b/w target load plan and cbl?
Answer
# 1
Target load plan is that you can set at the Informatica 
level whereas the Constraint based load ordering is what 
happens at the database side.

Whenever you have multiple pipelines in your mapping, you 
can set the order of execution of those pipelines, which to 
run first and which next. Whenever u select the target load 
plan, it displays the list of source qualifiers lying in 
the different pipelines. You just need to arrange the 
source qualifier as per your requirement and save your 
mapping.

Constraint based load ordering is an option in the session 
properties where the informatica understands that the 
parent table has to be loaded before the child table. You 
need not determine which table to load first and which 
next, all you need to do is just check the 'Constraint 
based load ordering' option in the session properties. This 
applies when you have multiple targets in the same pipeline 
simultaneously(like multiple targets from the same 
transformation or multiple targets from the same output 
group of a router etc..)
 
Is This Answer Correct ?    2 Yes 0 No
Sai Krishna Karri
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
How to improve the performance of Aggregate transformation? Dmss2
which quality process u can approach in ur project CTS1
what is plsql table?  1
What is the procedure to load the fact table.Give in detail?  1
How can you access the remote source into your session?  1
From where we can start or use pmcmd?  2
Without using Lookup & Sequence Generator, How to generate Sequence?  2
how do u use sequence created in oracle in informatica? Explain with an simple example CTS2
Why is meant by direct and indirect loading options in sessions?  3
Can any body tell about the (UTC) unit test cases with the examples in informatica.  3
What are two types of processes that informatica runs the session?  2
How can you complete unrcoverable sessions?  1
What are parallel querys and query hints?  1
if the session fails after 100 records agian we have to starts the session or we go for recovery session TCS2
what is Partitioning ? where we can use Partition?  1
what happens when a batch fails?  3
If we have lookup table in workflow how do you trouble shhot to increase performance?  2
How to delete duplicate record in Informatica?  3
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule. Satyam2
How the informatica server increases the session performance through partitioning the source?  1
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com