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...


Hey I am net to informatica? Can any one explain me step by
step How scd will work ?



Hey I am net to informatica? Can any one explain me step by step How scd will work ?..

Answer / srinu

Selects all rows.
Caches the existing target as a lookup table.
Compares logical key columns in the source against
corresponding columns in the target lookup table.
Compares source columns against corresponding target
columns if key columns match.
Flags new rows and changed rows.
Creates two data flows: one for new rows, one for changed
rows.
Generates a primary key for new rows.
Inserts new rows to the target.
Updates changed rows in the target, overwriting existing
rows.

Is This Answer Correct ?    6 Yes 2 No

Post New Answer

More Informatica Interview Questions

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,


How do you migrate data from one environment to another?

0 Answers  


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,


Kimball and Inmon methodologies?

2 Answers  


What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  


What is the term PIPELINE in informatica ?

7 Answers   Deloitte,


HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,


can session assigned multiple mappings or not?

2 Answers   Zensar,


What is workflow monitor?

0 Answers  


i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  


can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,


What is operational data source (ODS)?

7 Answers  


Categories