Answer Posted / subh
Normally one time loading process is followed for time
dimension. this might be achived by running one time insert
script.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
COM components can be used in Informatica
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How can you validate all mappings in the repository simultaneously?
How to call shell scripts from informatica?
What is the surrogate key?
What do you understand by term role-playing dimension?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How can you differentiate between powercenter and power map?
Implementation methodology
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to differentiate between the active and passive transformations?
What is an Integration service in Informatica?
If informatica has its scheduler why using third party scheduler?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?