Interested to Buy Any Domain ? << Click Here >> for more details...
why do we go for update strategy tr in SCD rather using the
session properties?
- 3 Answers
- 16842 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shweta
Actually its important to use a update strategy
transofmration in the SCD's as SCDs maintain some historical
data specially type 2 dimensions. In this case we may need
to flag rows from the same target for different database
operations. Hence we have no choice but to use update
strategy as at session level this will not be possible.
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
what is song in infrmatica...?
How to use pmcmd utility command?
How might one distinguish in the case of mapping is right or not without associating session?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain what are the different types of transformation available in informatica.
Can we get 1st record through Informatica(without sequence number).
Tell me about MD5 functions in informatica
How do you load first and last records into target table?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is status code in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is informatica?
Mention few advantages of router transformation over filter transformation.
Which files are created during the session rums by informatics server?
What is intricate mapping?
