On lookup on any table we can get only a)any value or b)last value but if i ne

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

3 Answers
7242 Views
I also Faced
E-Mail Answers

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

daily how much amount of data send to production?

4 Answers HSBC,

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers Wipro,

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers HCL,

What are variable ports and list two situations when they can be used?

1 Answers

What does cheating measurement mean?

0 Answers

What are ETL Tools?

0 Answers Informatica,

explain about session partitions ?

1 Answers

What are the different threads in DTM process?

2 Answers

How to go to the older version for a mapping?

0 Answers

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers Infosys,

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers Accenture,

For more Informatica Interview Questions Click Here