Interested to Buy Any Domain ? << Click Here >> for more details...
Where we use dynamic lookup and where we use it?do we
generate surrogate keys using dynamic lookup?can we use it
for scd type 2 mapping and why?
- 3 Answers
- 17864 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / nayan naik
Dynamic lookup when used in a SCD-2 implementation ,you must
make sure your lookup transformation is on the target table,
hence the dynamic lookup cache is always in sync.
Surrogate keys are generated using a sequence and not a
lookup transformation. Have a look at this link it gives you
a complete step by step implementation of SCD-2 in informatica.
http://deepinopensource.blogspot.in/2013/03/scd-2-implementations-in-informatica.html
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is flashback table ? Advance thanks
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Quickly characterize reusable change?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
which one is better performance wise joiner or look up
r u done any partitions in ur project?
What are the features of complex mapping?
What is joiner transformation?
What is data transformation manager process?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How do you handle two sessions in Informatica
Separate from an archive server and a powerhouse?
What is powercenter on grid?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Differentiate between sessions and batches?
