Can We Lookup A Table From Source Qualifier Transformation. Ie. Uncon

1.	Can We Lookup A Table From Source Qualifier Transformation. Ie. Unconnected Lookup?
Answer» You cannot LOOKUP from a source qualifier DIRECTLY. However, you can OVERRIDE the SQL in the source qualifier to join with the lookup table to PERFORM the lookup. You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup.

Can We Lookup A Table From Source Qualifier Transformation. Ie. Unconnected Lookup?

Answer»

You cannot LOOKUP from a source qualifier DIRECTLY. However, you can OVERRIDE the SQL in the source qualifier to join with the lookup table to PERFORM the lookup.

You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup.

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?

Can We Lookup A Table From Source Qualifier Transformation. Ie. Unconnected Lookup?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment