What are the three tiers in etl?
No Answer is Posted For this Question
Be the First to Post Answer
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
Explain about power designer data modeling software?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is etl process? How many steps etl contains?
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 difference between cardinality and Nullability?
what are the facilities provided by data warehouse to analytical users?
how do u set partition points in the mapping?
if u can't find what you are looking for in lookup table, how do you handle?
What is data cleaning?
Two default user groups created in the repository are____and_____.
What are the different Lookup methods used in Informatica?