Answer Posted / niranjana
Datawarehouse objects are Dimension tables,Fact tables,Unique identifiers and relationships
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is repository manager?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
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?
Explain the types of transformations?
Explain pushdown optimization and types in informatica
Parameter and variable differences
Can anyone tell me the new features in Informatica 9 Version?
What are the types of lookup transformation?
What is a mapplet/worklet in informatica?
What is a sorter transformation?
What are the components of Informatica? And what is the purpose of each?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the need of an ETL tool?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is InformaticaPowerCenter?