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 / 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
What is domain and gateway node?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain how to import oracle sequence into informatica?
What is target load order?
What are pre and post-session shell commands?
How to handle decimal places while importing a flatfile into informatica?
How do you update the records with or without using update strategy?
What is difference between a gateway node and worker node?
what are the deliverables?in your project?
can u give example for factless fact table
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to partition the Session?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How to improve the performance of a session using sorter transformation?