how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answers were Sorted based on User's Feedback
Answer / guest
we can join two table by using source qualifier t/r
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / swathi
using source qualifier and also lookup transformation,
joiner lookup
--------------------------------------------
active t/r passive t/r
supports horizontal merging supports horizontal merging
supports only equi join both equi& non equi join
Is This Answer Correct ? | 4 Yes | 1 No |
how would u estimate the size of Aggregator transform data and index cache?
how do use session mapping parameters ?(in which transformation)
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
what is the difference between cardinality and Nullability?
how do u set partition points in the mapping?
How to know informatica conslole password??
What are materialized views & where do we use them?
what is the difference between OLTP database and data warehousing database?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
How can we use external procedural logic in informatica?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Explain about etl data integration software?