What are the diffrences between joiner transformation and
source qualifier transformation?
Answers were Sorted based on User's Feedback
Answer / swetha
yoU can join hetrogenious data sources in joiner
transformation which we can not achieve in source qualifier
transformation. yoU need matching keys to join two
relational sources in source qualifier transformation. Where
as you doesn't need matching keys to join two sources. Two
relational sources should come from same datasource in
source qualifier. yoU can join relatinal sources which aer
coming from different sources also.
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / david
One important thing is
IN source Qualifier 1)the columns used in the condition must
have primary-key and foreign-key relationship(Compulsory)
For example
If the condition is
Emp.deptno = dept.deptno1
The depeno and deptno1 should have primary and foreign
key relation
2)The datatypes of the couumns must be same
Is This Answer Correct ? | 11 Yes | 1 No |
What is deployemnt groups, Lables, query and dynamic deployment group.
What is the function of look up transformation?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
What is deployment group?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
how to join the 2 different table with different columns in informatica?
What is confirmed dimension?
What is query panel?
how to identify new and old values in source qualifier or any other transformations using informatica
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????