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
- 16950 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
How can we use batches?
Write the prerequisite tasks to achieve the session partition?
Global and Local shortcuts. Advantages.
Can we override a native sql query within informatica?
In development project what is the process to follow for an etl developer from day1
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to generate sequence numbers without using the sequence generator transformation?
What is sorter transformation?
Quickly characterize reusable change?
Whats there in global repository
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Which version configuration tool used in ur project?
what is the size of u r source(like file or table)?
How to use pmcmd utility command?
In how many ways we can create ports?
