Answer Posted / vino
i Think,
You can split the dimension tables into two and can join
the two separate dimemsion tables by the surrogate key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
write a query to retrieve the latest records from the table sorted by version(scd)
What is native users?
how many types of dimensions are available in informatica?
Clarify the aggregator change?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What does cheating measurement mean?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is complex mapping?
Quickly characterize reusable change?
What is the benefit of partitioning a session?
What are the types of schemas we have in data warehouse.
What is Cognos script editor?
How to load data in informatica ?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Difference between Target-based loading and constraint-based loading?