Answer Posted / praveen kumar pendekanti
If a dimension exists in more than one fact table is known
as confirmed dimension. For every fact table confirmed
dimension should be there ex:: Time dimension....
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What is the use of target designer?
To import the flat file definition into the designer where should the flat file be placed?
How might one distinguish in the case of mapping is right or not without associating session?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What you know about transaction control transformation?
Differences between connected and unconnected lookup?
What are active and passive transformations?
Mention few advantages of router transformation over filter transformation.
What if the source is a flat-file?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What will be the approach?
What is fact table? Explain the different kinds of facts.
Explain target update override in informatica
What is meant by LDAP users?