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 the size ur source like(file system or database)? how many record daily come u r banking project?

2101


Differentiate between reusable transformation and mapplet.

1040


How are the sources and targets definitions imported in informatica designer?

1063


What is the status code in stored procedure transformation?

1130


What are the types of caches in lookup? Explain them.

927


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7094


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1059


Which transformation is needed while using the Cobol sources as source definitions?

1132


How would you join a node to the already existing domain?

1078


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6057


What is a joiner transformation and why it is an active one?

1014


What is union transformation in informatica?

1103


Can we change Dynamic to Static or Persistent cache? If so what happens?

2154


What are the static cache and dynamic cache in informatica?

1146


Clarify the utilization of aggregator cache record?

956