What are slowly changing dimensions?
- 5 Answers
- 28857 Views
- Informatica, Verinon Technology Solutions, I also Faced
- E-Mail Answers
Answer Posted / sandeep.t nizamabad
DIMENSIONS ARE CLASSIFIED INTO THREE TYPES
SCD TYPE-1 (MAINTAIN CURRENT DATA)
SCD TYPE-2 (MAINTAIN CURRENT DATA+FULL HISTORY OF CHANGES)
SCD TYPE-3 (MAINTAIN CURRENT DATA+ONE TIME HISTORY)
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
can you please explain me pre session and post session options?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the use of code page?
Write the unconnected lookup syntax?
Did u used latest transformations of 8.6.0? for what?
How do you change a non-reusable transformation to reusable transformation?
What is the benefit of partitioning a session?
What does refresh system mean, and what are its distinctive choice?
How to implement security measures using repository manager?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Does an informatica transformation support only aggregate expressions?
What is the difference between informatics 7x and 8x and what is latest version?
What are the guidelines to be followed while using union transformation?
What is a snowflake schema?
