What are slowly changing dimensions?

Answer Posted / anitha

scds are three types.
type1:it stores the current data.

type2:it stores the full historical data.

type3:it stores the current and previous data in the target...

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the prerequisite tasks to achieve the session partition?

815


What are the data movement modes in informatica?

797


What is lookup transformation?

712


Define Pmrep command?

726


How to extract sap data using informatica?

698






Explain how many types of dimensions are available in informatica?

682


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2387


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1168


What is the use of an aggregator cache file?

782


what is $$$$?

1826


Global and Local shortcuts. Advantages.

1570


Implementation methodology

1352


What is transformation?

770


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6735


Explain the types of transformations?

696