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

On lookup on any table we can get only a)any value or b)last
value but if i need both duplicate values How can i achieve?

Question Posted / srinivas.medagum

Answers were Sorted based on User's Feedback



On lookup on any table we can get only a)any value or b)last value but if i need both duplicate va..

Answer / maneesh

To get both the duplicate values, use JOINER

Is This Answer Correct ?    3 Yes 0 No

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate va..

Answer / pradeep

We wil go for left outer join on the lookup table in the
source qualifier sql override so that it wil return both the
records.

Is This Answer Correct ?    1 Yes 0 No

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate va..

Answer / suresh

actually on lookup two ways we can put the values normally
we put a anyvalue(if you want to both duplicate values).
when we use SCD type 2 its must and should put on last value
into the look up Bcoz it should store the history.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Informatica Interview Questions

How to import oracle sequence into Informatica?

3 Answers   Satyam,

guys which is the best institute in banglore to learn informatica??

2 Answers  

What is the sequence generator transformation in informatica?

0 Answers  

can you use flat file for repository?why?

2 Answers   TCS,

From where we can start or use pmcmd?

3 Answers  

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

Explain what are the different types of transformation available in informatica.

0 Answers  

What is the capacity of power cube?

1 Answers  

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  

WHat all joins are there in Source Qualifier?

1 Answers  

What are the uses of a Parameter file?

3 Answers   CSC,

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories