Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ankit kansal
Lookup is used to check whether the row corresponding the incoming row is present or not and if yes then perform some logic and if not then do some other like we use to do it case of SCD2.
So, It is purely a left outer join where left table is your source table.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the different Lookup methods used in Informatica?
Do we need an ETL tool? When do we go for the tools in the market?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What is staging area referring to?
Explain about power designer data modeling software?
How etl testing is different from database testing?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
what is the use of structures?how many nodes can u create in a structure?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Define Dynamic push down optmization?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
when will use SQL override in a lookup transformation?
What is tracing level?
can be used COM component in Informatica ?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
