What is Factless fact table ???
Answer Posted / tadikonda
FACT TABLE CONTAINS ONLY ID,KEYS AND DESCRIPTION COLUMNS AND
NOT MEASURES ARE KNOWN AS FACTLEES FACT TABLES
| Is This Answer Correct ? | 33 Yes | 4 No |
Post New Answer View All Answers
what is degenerated dimension?
How many input parameters can exist in an unconnected lookup?
Define mapplet?
What is joiner change?
Can informatica load heterogeneous targets from heterogeneous sources?
How to convert multiple rows to single row (multiple columns) in informatica
Define pmcmd command?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is native users?
What is workflow? What are the components of workflow manager?
How can we store previous session logs?
What are the differences between source qualifier and joiner transformation?
What is mapplet in informatica?
On which transformations you created partitions in your project?
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.