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
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to partition the Session?
Define update strategy?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is a snowflake schema?
What is an active transformation?
What are the performance considerations when working with aggregator transformation?
what is index?how it can work in informatica
What is a stored procedure transformation?
What is the difference between informatica 7.0 and 8.0?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is main use of mapplet?
How to create or import flat file definition in to the warehouse designer?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
how to create user defined function (udf) in informatica