Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

What is domain and gateway node?

1203


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?

2071


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2103


Explain how to import oracle sequence into informatica?

1069


What is target load order?

1297


What are pre and post-session shell commands?

1380


How to handle decimal places while importing a flatfile into informatica?

1238


How do you update the records with or without using update strategy?

1160


What is difference between a gateway node and worker node?

1199


what are the deliverables?in your project?

2194


can u give example for factless fact table

6771


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

2148


How to partition the Session?

1149


what is the size ur source like(file system or database)? how many record daily come u r banking project?

2189


How to improve the performance of a session using sorter transformation?

1186