How or for what purpose look up transformation would be
useful in Sales or Banking Project?
Please reply!
Answer Posted / raj
For maintaining the complete history we need to look up on
the target table especially in sales and banking projects we
use SCD2 type mappings for maintain the complete history.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain about cumulative Sum or moving sum?
how we can load rejected record's at run time?(not through bad files)
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Name the different lookup cache(s)?
Is it possible to create multiple domains on a single Informatica server?
Explain the code page compatibility?
What is Index Caches size?
What are the different lookup cache(s)?
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.
What is informatica metadata and where is it stored?
What is a standalone command task?
What is domain and gateway node?
Explain scd type 3 through mapping.
Differentiate between a database and data warehouse?
Differences between connected and unconnected lookup?