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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / kumar

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

How to recover sessions in concurrent batches?

3 Answers  

What are ETL Tools?

0 Answers   Informatica,

What happens if we dont select data driven option?

2 Answers   Zensar,

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

Explain the types of transformations?

0 Answers  

Define enterprise data warehousing?

0 Answers  

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

what is plsql table?

2 Answers  

For more Informatica Interview Questions Click Here
Categories