Which is better performance wise database or file?How?
Answer Posted / gyana
flat files are good for performance....
but fixed width files are more better than a delimited flat file......
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What does “tail –f” command do and what is its use as an Informatica admin.
Briefly define reusable transformation?
What is the surrogate key?
Explain how many types of dimensions are available in informatica?
What is expression transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is mean by complex business rule ?
How to do unit testing in informatica? How to load data in informatica ?
Write the advantages of partitioning a session?
Differentiate between Load Manager and DTM?
Why do you use Mapping Parameter and mapping variable?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Write the different tools in the workflow manager?
Write the prerequisite tasks to achieve the session partition?