HOW TO GET THE LATEST DATA IN SCD ?

Answer Posted / vikneswaran

in type 1 ... only the latest date... so it is very easy to get

in type 2.. to get by using date or flag or version

in type 3.. to get by selecting previous_column

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Clarify the utilization of aggregator cache record?

566


In informatics server which files are created during the session rums?

620


How do you load first and last records into target table?

652


What all join we can perform in LOOKUP transformation?

548


What is standalone command task?

695






What is a node in Informatica?

611


What is informatica worklet?

596


If informatica has its scheduler why using third party scheduler?

759


What is the function of aggregator transformation?

568


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1578


What is a code page?

700


What you know about transaction control transformation?

546


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1455


Whats the difference between informatica powercenter server, repositoryserver and repository?

662


What is rank transformation in informatica

680