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                      
tip   SiteMap shows list of All Categories in this site.
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 
wht is cdc?how to use it in creation of mappings?
 Question Submitted By :: Srinivasarao
I also faced this Question!!     Rank Answer Posted By  
 
  Re: wht is cdc?how to use it in creation of mappings?
Answer
# 1		 
CDC stands for change data capture. This is used to 
implement incremental load approach in data warehouse. 
In this approach we traditionally keep a date field and 
pull data on incremental date values.
This assures that we are picking latest data (Or may be new 
batch data which ever is applicable).
Implementing this in mapping would require you to use 
parameter files which will keep HiWaterMark and LoWatermark 
which is repeatedly used to capture fresh data.
 
Is This Answer Correct ?    2 Yes 0 No
Vaibhav Bhandeo
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
what is lookup ?  4
Howmany ways yoU can update a relational source defintion and what are they?  1
What is critical mapping?  1
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse TCS4
can anyone explain me about sales project in informatica? Satyam1
surrogate keys usage in Oracle and Informatica? Oracle3
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use? TCS6
What is Datadriven?  2
What is the difference between Bitmap and Btree index?  1
How to recover the standalone session?  2
How to improve the performance of Aggregate transformation? Dmss2
What is a diff between joiner and lookup transformation UHG8
What are the Differences between static cache and dynamic cache?  1
Why touse stored procedure in ETL Application?  1
what happens if you try to create a shortcut to a non- shared folder?  1
What are limitations of joiner transformation?  2
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .? HP5
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?  2
How to compare Source and Target table, without using dynamic lookup?  1
wht is cdc?how to use it in creation of mappings? HSBC1
 
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