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
- 1 Answers
- 2324 Views
- I also Faced
- E-Mail Answers
Answer / Vishal Sharma
If you have missing fact records in a flat file and decide to load only the dimension records, it means that the corresponding facts will be incomplete or missing. It's essential to ensure that both fact and dimension records are loaded to maintain data integrity and accuracy in your data warehouse.
| Is This Answer Correct ? | 0 Yes | 0 No |
my source is junk data how will u remove that junk data by using unix please any one replay me
What is meta data and system catalog?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
Can we override a native sql query within informatica?
How can you run a session without using server manager?
How many mapplets u have created? and what is the logic used
Mention a few design and development best practices for informatica?
WAT IS TEXT LOAD?
explain about informatica server architecture?
What is mapping debugger?
Router T/R is active but some people are saying it is also passive which is exactly right?
what is runtime variable?
Teradata 
