Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pune.rohitsharma
my ans is
1)date range
2)key
3)flag
here i have one thing to say
what about with pk key and with out pk will it come into
picture when we are talking about diff ways of implementing
SCD type 2
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Explain what are the different types of transformation available in informatica.
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How many ways are there to create ports?
What are the differences between joiner transformation and source qualifier transformation?
How to differentiate between the active and passive transformations?
design of staging area?
What are the limitations of joiner transformation?
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
What are junk dimensions?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What the difference is between a database, a data warehouse and a data mart?
In which transformation you cannot drag ports into it?
