Answer Posted / ashish
Use Desc Table_name
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
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 what is etl process? How many steps etl contains explain with example?
What are dimensions?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Explain about power designer data modeling software?
how do u handle performance issues in Informatica . where can u monitor the performance ?
what is the meaning of upgradation of Repository?
Explain about etl data integration software?
explain the methodology of Data Warehousing?(Polaries)
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is the difference steps for data modeling?
What are the various tools used in etl?
Explain do we need an etl tool? When do we go for the tools in the market?
SCD2 will work on only dimension tables as well as fact Table?