IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
Answers were Sorted based on User's Feedback
Answer / shashiall
plz..use "update else insert" in the properties of session.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / saritha
You can use Joiner transformation to design scd Type1
manually. Import target as source and use joiner
transformation. Use expression to insert and update the
rows into target.
Is This Answer Correct ? | 0 Yes | 0 No |
If we have lookup table in workflow how do you trouble shhot to increase performance?
in performance wise union is past,union all is past
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
How you can differentiate between connected lookup and unconnected lookup?
What is a surrogate key?
What is informatica? Why do we need it?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
What are the types of schemas we have in data warehouse and what are the difference between them?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the default join that source qualifier provides?
What is native users?
How to prepared lld.can any one tell me detailed explanetion.