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

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

What is a filter transformation and why it is an active one?

0 Answers  

What is confirmed dimension with scenario

1 Answers   HCL,

How to load a relational source into file taget?

2 Answers  

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

lookup transformation with screenshots

0 Answers   TCS,

How will u find weather dimension table is big in size of a fact table?

1 Answers  

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,

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

0 Answers   Informatica,

what are presession,postsession success and postsession failure commands ?

1 Answers  

How many joins in Informatica

5 Answers   CSC,

For more Informatica Interview Questions Click Here
Categories