What is the difference between Junk and Confirmed Dimention?
where can be used htat one in Informatica?
Answer Posted / chaitanya
An interesting use for a junk dimension is to capture the context of a specific transaction. While our
common, conformed dimensions contain the key dimensional attributes of interest, there are likely
attributes about the transaction that are not known until the transaction is processed.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we change Dynamic to Static or Persistent cache? If so what happens?
How do you load only null records into target?
Explain about cumulative Sum or moving sum?
What is difference between a gateway node and worker node?
Explain the types of lookup transformation?
What is a filter transformation?
What is data caches/ index caches?
Explain in detail about scd type 1 through mapping.
What is data transformation manager process?
What the difference is between a database, a data warehouse and a data mart?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Why do you use Mapping Parameter and mapping variable?
What does “tail –f” command do and what is its use as an Informatica admin.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.