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

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2182


hi real timers . iam waiting for ur reply regarding ETL TESTING

2271


What is an expression transformation?

1016


Is there any target staging area in informatica not staging area

2580


What is dimensional table? Explain the different dimensions.

1172


How to load the data from people soft hrm to people soft erm using informatica?

1020


Enlist the differences between database and data warehouse.

1120


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979


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

1146


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

6181


How to do unit testing in informatica? How to load data in informatica ?

1121


What do you understand by a term domain?

1125


Explain what are the different versions of informatica?

1099


What is different between the data warehouse and data mart?

1066


How many input parameters can exist in an unconnected lookup?

1545