Interested to Buy Any Domain ? << Click Here >> for more details...
from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
- 21 Answers
- 40662 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / prakash
USE NOCACHE,IT WILL GIVE BETTER PERFORMANCE RATHER THAN
JOINER
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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
What are some examples of informatica etl programs?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is joiner transformation?
What are the components of Informatica? And what is the purpose of each?
How are indexes created after completing the load process?
what are factless facts? And in which scenario will you use such kinds of fact tables.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain what is informatica metadata and where is it stored?
How do you set a varible in incremental aggregation
Explain the difference between a data warehouse and a data mart?
How do you load unique records into one target table and duplicate records into a different target table?
what is size of u r database?
Briefly explain the aggregator transformation?
What is the surrogate key?
