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
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 ?
SCD2 will work on only dimension tables as well as fact Table?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
List few etl bugs?
What is data cleaning?
dimension object created in oracle can be imported in designer?how?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
what is data modeling?
what is session partitioning?
How many steps etl contains explain with example?
What is lookup table in etl 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
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
where are the log files generally stored.Can you change the path of the file.what can the path be?
What is partitioning? Explain about round-robin, hash partitioning.
