How many steps etl contains explain with example?
No Answer is Posted For this Question
Be the First to Post Answer
When do we go for the tools in the market?
How can we use external procedural logic in informatica?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
how do use session mapping parameters ?(in which transformation)
what is dynamic insert?
how many steps are there in etl process?
What is full load & incremental or refresh load?
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 is the indicator file and where it is used?
how do u really know that paging to disk is happening while u are using a lookup transform?
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
Explain the key challenges that you face while performing etl testing.