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...


How to compare Source and Target table, without using
dynamic lookup?

Answers were Sorted based on User's Feedback



How to compare Source and Target table, without using dynamic lookup?..

Answer / nagaraju bhatraju

YOu can join the Source and target columns at the source
qualifer level,if you have public synonym on the target, so
that the table can be accessed from all the schemas.

Is This Answer Correct ?    6 Yes 3 No

How to compare Source and Target table, without using dynamic lookup?..

Answer / davan

Am not sure ..default join of look is left out join
so...use of joiner t/r with left outer join..we have to
look up.

Is This Answer Correct ?    1 Yes 0 No

How to compare Source and Target table, without using dynamic lookup?..

Answer / xxx

Using Unconnected LKP transformation

Is This Answer Correct ?    0 Yes 0 No

How to compare Source and Target table, without using dynamic lookup?..

Answer / b

using MINUS operator in SQ override

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Briefly define a session task?

0 Answers  


complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,


how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,


Describe data concatenation?

0 Answers  


Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  


What are two types of processes that informatica runs the session?

2 Answers  


In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,


What are the joiner caches?

3 Answers   Informatica,


My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,


tell me the informatica architecture

1 Answers   Banca Sella, Wipro,


How many numbers of sessions can one group in batches?

0 Answers  


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,


Categories