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
What are roles and groups and benefits of using them?
how many types of dimensions are available in informatica?
What are batches?
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.
Explain the tuning lookup transformation - informatica
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?
-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?
Does an informatica transformation support only aggregate expressions?
COM components can be used in Informatica
Explain the difference between mapping parameter and mapping variable?
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
Slowly changing dimensions, types and where will you use them
Plz can any one say me how to get the informatica certification materials and dumps
What is an unconnected transformation?
What is a rank transform?