Give a way in which u can implement a real time scenario
where data in a table is changing and u need to look up data
from it.How will u configure the look up transform for this
purpose?
In case a table is getting changed constantly,... u need to
make a lookup of the target table with the source table.
and put an incremental load logic. If you want the logic I
can explain this anytime. :)
| Is This Answer Correct ? | 0 Yes | 1 No |
what are the data modeling tools you have used?(polaris)
if i have a query as flat file how can we load data to target table
Compare etl & elt?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
How many steps etl contains explain with example?
what are the different Reporting and ETL tools available in the market?
What is etl process. How many steps etl contains explain with example?
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 ?
what is meant by drill through?(Mascot)
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.
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what are the data modeling tools you have used?(polaris)