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

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,




my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

what is runtime variable?

3 Answers   TCS,

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

Mention some types of transformation?

0 Answers  

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,

What is powercenter on grid?

0 Answers  

For more Informatica Interview Questions Click Here
Categories