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

What are slowly changing dimensions?

Question Posted / ande

Answer Posted / ande

there are three types SCD:
type-1: in this we can over write original recourd with new
record
type-2: we can create new record
type-3: we can create new attribute
regards,
ande

Is This Answer Correct ?    9 Yes 23 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1703

 Informatica Checkpoints

2867

Explain about Informatica server process that how it works relates to mapping variables?

634

How to update or delete the rows in a target, which do not have key fields?

661

Can we override a native sql query within informatica?

634




What is the difference between router and filter?

654

In how many ways we can create ports?

710

What differs when we choose the sorted input for aggregator transformation?

576

What is a node in Informatica?

638

in reporting we add some new objects,how we get the count of the newly added objects to the report

1762

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6760

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1416

Different circumstance which drives informatica server to expel records?

560

Can u generate reports in Informatica?

661

What is a grid in Informatica?

622