Answer Posted / nivas
Surrogate key is a system generated sequence numbers. It is
also called artificial key.Sarrogate key using as a primary
key without using sarrogate key we can't do SCD type2
implemenation.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the need for an etl tool?
How to load a Dimension ? and how to load a fact table?
what is diff b/t sorter t/r and agg have the option sorter property...
What do you mean by blocking transformation?
What are the advantages of using informatica as an etl tool over teradata?
What are the restrictions of union transformation?
What is the need of etl tools?
Explain about cumulative Sum or moving sum?
Is it possible to use a client with different version than that of its Informatica server?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is event and what are the tasks related to it?
How to elaborate powercenter integration service?
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
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?