ALLInterview.com :: Home Page            
 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                      
Google
   
 
Categories >> Software >> Data Warehouse >> Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (755)
 Cognos interview questions  Cognos Interview Questions (848)
 Informatica interview questions  Informatica Interview Questions (1623)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (171)
 Data Stage interview questions  Data Stage Interview Questions (563)
 SAS interview questions  SAS Interview Questions (556)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
Question
what is incremental loading ?
 Question Submitted By :: Informatica
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
Incremental load is adding/inserting only changed/latest
data from the source.In incremental loading,history data
could remain as it is along with the new data or
overwritten by incremental data.
 
Is This Answer Correct ?    52 Yes 7 No
Preeti
 
Answer
# 2
capturing the chnged data from the source using the concept
of mapping variable for timestamping is known as
incremental loading.

the other load type is full load where we go for full
refresh.
 
Is This Answer Correct ?    30 Yes 6 No
Bsgsr
 
 
 
Answer
# 3
it is a process of considering only new records by omitting
existing records for data load is known as incremen loading.
 
Is This Answer Correct ?    12 Yes 8 No
Chandramohan Reddy
 
Answer
# 4
Incremental loading is load the

History data
Present data

and add insert new data to the table
 
Is This Answer Correct ?    24 Yes 21 No
Rajendra
 
Answer
# 5
increamental loading is the concept of capturing the new
records and updated records from the source it is very help
full in scd's - 2
 
Is This Answer Correct ?    7 Yes 4 No
Vijay
 
Answer
# 6
Incremental loading is nothing but the cdc(change data
capture)
used to capture the data like insert,update and deleted
data on a table.
1)for this we need exec the sp against the db is to enable
the cdc.(select is_cdc_enabled where db_name='cdc_test')
2)Enable the cdc against the table in the db.(exec
sys.sp_cdc_enable_table @source_schema=-----,@source_name=-)
3)wheather the db/table enabled for the cdc by writing a
select query aginst db/table.If it returns 1 enabled or it
returns 0 not enabled.
(select is_tracked_by_cdc from sys.tables where tab_name='--
--')



any suggetions revert me via ravipati65@gmail.com

apps
 
Is This Answer Correct ?    6 Yes 4 No
Apps
 
Answer
# 7
Incremental load is adding/loading only changed/latest updated
data from the source.In incremental loading,history data
could remain as it is along with the new data or
overwritten by incremental data and also the other load type is full load where we go for full refresh.
 
Is This Answer Correct ?    2 Yes 0 No
Sekhar
 
Answer
# 8
Last__Extract_Date = The date Fro which you need the data(to
get latest records)
 
Is This Answer Correct ?    0 Yes 0 No
Razeen
 
Answer
# 9
In Incremental loading the differnce between the source and
target are dumped at regular intervals. Here we give the
last extract date so that changes only of this particular
date will be loaded to the target tables.
 
Is This Answer Correct ?    0 Yes 0 No
Gopinath
 
Answer
# 10
it is a process of considering only new records by omitting
existing records for data load is known as incremental loading.
 
Is This Answer Correct ?    4 Yes 12 No
Sankar Naidu.talluru
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure? Wipro 1
what is incremantal aggregation?   1
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .   1
What are the different threads in DTM process?   1
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?   5
What is aggregate awareness?   1
if the session fails after 100 records agian we have to starts the session or we go for recovery session TCS 2
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail AMDOC 2
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping? DELL 5
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence IBM 1
how can u connect client to ur informatica sever iff server is located at different place( not local to the client) Accenture 3
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session?? TCS 9
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com