What is Factless fact table ???
- 12 Answers
- 41425 Views
- Satyam, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / m.mahendra
The fact table which contains the business events or
coverage that could be represented in a fact table, but
there will be no measures or facts associated with these.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is a surrogate key?
Clarify the aggregator change?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
what is mean by complex business rule ?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Implementation methodology
Explain in detail about scd type 1 through mapping.
What is the session task and command task?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
tell me 5 session failure in real time how can you solve that in your project?
How do you load only null records into target? Explain through mapping flow.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
what is unit testing?tell me proceedure
