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?

Answer Posted / maneesh

To get both the duplicate values, use JOINER

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is lookup change?

624


Briefly define reusable transformation?

629


On which transformations you created partitions in your project?

763


Explain lookup transformation is active in informatica

665


Why union transformation is an active transformation?

659






Tell me about Propagate functions in informatica

528


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2299


Different sorts of metadata that stores in the storage facility?

564


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1467


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1857


What are the types of caches in lookup?

577


How are the sources and targets definitions imported in informatica designer?

672


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1760


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

786


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1941