Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6082 Views
- I also Faced
- E-Mail Answers
Answer Posted / naga
We can write Left outerjoin with the target in Source
Qualifier itself or if ur src is file & target is Table
then using Joine(Left outer) can get the new rows loaded
into target
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Enlist few areas or real-time situations where informatica is required.
without table how to come first record only in oracle?
What are data-driven sessions?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the guidelines to be followed while using union transformation?
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?
What is the benefit of session partitioning?
How to update a particular record in target with out running whole workflow?
In which transformation you cannot drag ports into it?
How can we improve session performance in aggregator transformation?
What is a transaction control transformation?
Explain lookup transformation in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
How does the aggregator transformation handle null values?
