What Is The Difference Between Joiner And Lookup?

1.	What Is The Difference Between Joiner And Lookup?
Answer» joiner is used to join two or more tables to retrieve DATA from tables(just LIKE joins in sql). Look up is used to CHECK and compare source table and target table .(just like correlated sub-query in sql). joiner is used to join two or more tables to retrieve data from tables(just like joins in sql). Look up is used to check and compare source table and target table .(just like correlated sub-query in sql).

Answer»

joiner is used to join two or more tables to retrieve DATA from tables(just LIKE joins in sql).
Look up is used to CHECK and compare source table and target table .(just like correlated sub-query in sql).

joiner is used to join two or more tables to retrieve data from tables(just like joins in sql).
Look up is used to check and compare source table and target table .(just like correlated sub-query in sql).

Discussion

No Comment Found

Related InterviewSolutions

Techniques Of Error Handling - Ignore , Rejecting Bad Records To A Flat File , Loading The Records And Reviewing Them (default Values)?
What Is The Difference Between Joiner And Lookup?
What Are The Various Test Procedures Used To Check Whether The Data Is Loaded In The Backend, Performance Of The Mapping, And Quality Of The Data Loaded In Informatica?
Where Do We Use Connected And Un Connected Lookups?
What Is The Difference Between Informatica 7.0&8.0?
How Can I Edit The Xml Target, Are There Anyways Apart From The Editing The Xsd File. Can I Directly Edit The Xml Directly In Informatica Designer?
What Is Conformed Fact? What Are Conformed Dimensions Used For?
Define Non-additive Facts?
What Is Data Purging?
What Are The Different Problems That Data Mining Can Slove?

What Is The Difference Between Joiner And Lookup?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment