Answer Posted / ashis
Add to sweta's answer:
We use lookup transformation to lookup data from a
relational table, view, synonym or flatfile against another
or the same table, view, synonym or flatfile.
This is mainly(not only)used for SCD's. So that the value
in the source can be compared with the existing target.
Lookup transformation are of different types named and
unnamed.
Mostly used lookup transformation types are Connected lookup
(Persistent Lookup, Dynamic lookup, Cached lookup, Uncached
lookup)
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How would you join a node to the already existing domain?
Describe an informatica powercenter?
can u any challenge your project?
What is a stored procedure transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How many input parameters can exist in an unconnected lookup?
What is persistent lookup cache?
have u done any performance tuning? how u ll do?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Define sessions in informatica etl?
what is unit testing?tell me proceedure
What is workflow manager?
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.
What is the use of target designer?
What is deployment group?