What is a diff between joiner and lookup transformation

Answer Posted / kalpana

joiner doesnt support nonequi joins where as lookup support
nonequijoin

Is This Answer Correct ?    72 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are roles and groups and benefits of using them?

569


how many types of dimensions are available in informatica?

559


What are batches?

617


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

780


Explain the tuning lookup transformation - informatica

608






If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8534


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4969


Does an informatica transformation support only aggregate expressions?

606


COM components can be used in Informatica

1871


Explain the difference between mapping parameter and mapping variable?

600


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1691


Slowly changing dimensions, types and where will you use them

1269


Plz can any one say me how to get the informatica certification materials and dumps

1595


What is an unconnected transformation?

659


What is a rank transform?

670