Answer Posted / nagendrareddy
unique is constraint which will not allow duplicate records
into batabase..
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain the difference between a data warehouse and a data mart?
Reusable transformation and shortcut differences
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Differentiate between a database and data warehouse?
What is meant by query override?
What are the types of lookup transformation?
What are the new features of informatica 9.x in developer level?
Explain sessions?
What is Session and Batches?
What is a difference between complete, stop and abort?
What is a repository manager?
Define sessions in informatica etl?