How many steps etl contains explain with example?
No Answer is Posted For this Question
Be the First to Post Answer
how would u estimate the size of Aggregator transform data and index cache?
what is data modeling?
How many types of transformations supported by sorted input?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
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.?
Explain etl mapping sheets?
Explain different types of partitioning?
how would u estimate the size of Lookup transform data and index cache?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
what is Forward,Reverse and Re_engineering?
SCD2 will work on only dimension tables as well as fact Table?