Is scd logic we have lookup right to compare the values with
source and target,instead of lookup can u have any
transformation or any way to do this?
Answer Posted / itsranjan
Hi, Joiner transformation can do the same job what lookup
does in SCD.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Clarify the aggregator change?
What are data-driven sessions?
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 is meant by a domain?
Why filter transformation is an active one?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How can one identify whether mapping is correct or not without connecting session?
explain about unit testing? in real time?
How to implement security measures using repository manager?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is aggregate cache in aggregator transformation?
What is the sequence generator transformation in informatica?
where to store informatica rejected data? How to extract the informatica rejected data?