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 dimensional table? Explain the different dimensions.

1110


How to extract sap data using informatica?

984


Is it possible to revert a global repository to local one and why?

1023


difference between informatica 8.1.1 and 8.6

3626


What is the sql query overwrite in source qualifier in informatica

1026


what are 3 tech challenges/ common issues you face?

2279


What is a pre-defined event and user-defined event?

972


What is the difference between router and filter?

1153


What is the difference between stop and abort in informatica

1042


How does a sorter cache works?

1000


what are factless facts? And in which scenario will you use such kinds of fact tables.

1740


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2350


Mention few power centre client applications with their basic purpose?

891


How do we call shell scripts from informatica?

1011


What is workflow monitor?

998