What is a diff between joiner and lookup transformation
Answer Posted / krishna
I) Joiner is active transformation & lookup is passive
transformation.
2)joiner having input port,output port, master port where as in lookup having input port, output port,lookup port,return port.
3) joiner having sorted inputs option where as lookup doesent have this option
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe data concatenation?
What is the format of informatica objects in a repository?
How do we call shell scripts from informatica?
How to load last n records of file into target table - informatica
What are active transformations.
What are the issues you have faced in your project? How did you overcome those issues?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain in detail scd type 2 through mapping.
How do you set a varible in incremental aggregation
How to create a non-reusable instance of reusable transformations?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is mapping debugger?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.