Answer Posted / rr
A dimension that will remains unchanged in entire
datawarehouse. It can be used across all the fact tables.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How to load the data from a flat file into the target where the source flat file name changes daily?
How can a transformation be made reusable?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How do you load unique records into one target table and duplicate records into a different target table?
Can informatica load heterogeneous targets from heterogeneous sources?
What is transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the types of caches in lookup? Explain them.
lookup transformation with screenshots
Explain lookup transformation is active in informatica
What is target load order?
What is union transformation in informatica?
Design time, run time. If you don't create parameter what will happen
What is pmcmd command?
What's the layout of parameter file (what does a parameter file contain?)?