What are the diffrences between joiner transformation and
source qualifier transformation?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean incremental aggregation?

716


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1734


Quickly characterize reusable change?

803


What is a stored procedure transformation?

687


What are mapplets?

908






Can we create a Integration service without a Repository service and vice versa?

834


can anyone suggest best free Talend data integration training online

1348


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1538


What is the format of informatica objects in a repository?

692


Describe the impact of several join conditions and join order in a joiner transformation?

734


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1826


What are Dimensional table?

691


Tell me about Propagate functions in informatica

620


Why do you use Mapping Parameter and mapping variable?

1377


What is a snowflake schema?

655