Answer Posted / chandrasekar
Fact tables are normalized. Dimension tables are denormalized
| Is This Answer Correct ? | 27 Yes | 0 No |
Post New Answer View All Answers
Quickly characterize reusable change?
What are the types of caches in lookup? Explain them.
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 INFORMATICA TESTING process
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a predefined event?
What is joiner transformation?
What are the main issues while working with flat files as source and as targets ?
What are the new features of informatica 9.x developer?
How you know when to use a static cache and dynamic cache in lookup transformation?
Under which circumstances, informatica server creates reject files?
How to go to the older version for a mapping?
Explain in detail scd type 2 through mapping.
What is the different lookup cache(s)?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?