can we create index and drop index in exsisting table while
using infomatica
Answer Posted / rekha
YES
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Differentiate between a repository server and a powerhouse?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the different lookup cache(s)?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
expain about the tune parameters?
How to load the data from people soft hrm to people soft erm using informatica?
Enlist the differences between database and data warehouse.
What are the different versions of informatica?
How to use procedural logic inside infromatica?
What is an expression transformation in informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What if the source is a flat-file?
What are data-driven sessions?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me