Interested to Buy Any Domain ? << Click Here >> for more details...
surrogate keys usage in Oracle and Informatica?
- 5 Answers
- 15576 Views
- ITC Infotech, Oracle, I also Faced
- E-Mail Answers
Answer Posted / palani
Its mainly used to maitain the uniqueness in the target
system that contains records from various source systems
ie. different source system may contain different keys as a
primary key.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to load rows into fact table in data warehouse
What all join we can perform in LOOKUP transformation?
What is Data Caches size?
Explain the different kinds of facts.
Define update strategy?
How to extract the informatica rejected data?
What is the difference between informatica 7.0 and 8.0?
Can we create a Integration service without a Repository service and vice versa?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How would you copy the content of one repository to another repository?
How you prepared reports for OLAP?
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
have u done any performance tuning? how u ll do?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
