what is the difference between lookupoveride and joiner?
Answer Posted / nikhil
Using lookupoverride u can join two relational tables but
not flat files . Joniner T is used to join two heterogenous
sources like relational tables from two different databases
or flat file sources.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Briefly define a session task?
Enlist the differences between database and data warehouse.
How can you generate reports in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
waht type of interface is used for testing the data in informatica
What is data caches/ index caches?
what is the size of u r source(like file or table)?
What does “tail –f” command do and what is its use as an Informatica admin.
what is unit testing?tell me proceedure
What all join we can perform in LOOKUP transformation?
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.
Why filter transformation is an active one?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Have you worked with/created Parameter file