Is apache nifi an etl tool?
No Answer is Posted For this Question
Be the First to Post Answer
How many types of transformations supported by sorted input?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
What is etl process?
what are the different Reporting and ETL tools available in the market?
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 are three tier systems in etl?
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.
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
what is HISTOGRAM? how to generate statistics?
what is the meant by Normalization and de-normalization?
How can we use external procedural logic in informatica?
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.?