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
- 17740 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
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the new features of informatica 9.x in developer level?
explain abt ur project architecture?
What is the cumulative sum and moving sum?
permutations of mapplet
What are the different types of repositories created using informatica?
How to join three sources using joiner? Explain though mapping flow.
What can we do to improve the performance of informatica aggregator transformation?
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
Define enterprise data warehousing?
What are the limitations of joiner transformation?
Explain Dataware house architecture .how data flow from intial to end?
What is union transformation?
What do you understand by a term domain?
How many number of sessions can one group in batches?
