how do u set the size of block buffer?
Answer / sarvesh
go to edit properties in any of the following trans like
rank,lookup,joiner,aggregator,there u can change the size
of buffer,but by dewfault it is 64kb.
Is This Answer Correct ? | 1 Yes | 0 No |
how would u estimate the size of Lookup transform data and index cache?
How etl testing is different from database testing?
what happens if the info.server doesn't find the session parameter in the parameter file?
what is granularity in Data ware House?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
can be used COM component in Informatica ?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
how do u really know that paging to disk is happening while u are using a lookup transform?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
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.?
how many steps are there in etl process?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.