Answer Posted / honey
A central table in a data warehouse schema that contains
numerical measures and keys relating facts to dimension
tables. Fact tables contain data that describes specific
events within a business, such as bank transactions or
product sales.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
what is size of u r database?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Which are the different editions of informatica powercenter that are available?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to load data in informatica ?
What is difference between a gateway node and worker node?
Partition, what happens if the specified key range is shorter and longer
draw informatica architecture 8.6 ?
How you can differentiate between connected lookup and unconnected lookup?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Performance tuning( what you did in performance tuning)
Does an informatica transformation support only aggregate expressions?
I have a flat file, want to reverse the contents of the flat file
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the components of Informatica? And what is the purpose of each?