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 is dynamic insert?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What is etl process? How many steps etl contains?
how do u set partition points in the mapping?
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
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Explain do we need an etl tool? When do we go for the tools in the market?
What is abap? What are idocs?
what is the use of server manager?
What is fact? What are the types of facts?
what are Lookup caches options? Including persistent caches.
how does the server recongnise the source and target databases.Elaborate on this
Can there be sub steps of etl steps?
How many types of transformations supported by sorted input?
what is pmrep command?
