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

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,


what is filelist concept in informatica

4 Answers  


What are the components of workflow manager?

0 Answers  


There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,


why we use informatica in our project?

2 Answers   TCS,


what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,


I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,


in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,


i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,


What is the status code?

1 Answers  


Do you find any difficulty while working with flat files as source and target?

0 Answers  


Please let me know how to make encryption and decryption with example?

0 Answers  


Categories