Why joiner transformation does not allow the aggregator
transformation and expression transformation to join
Answer Posted / abhishek
We can join the aggr and epx in joiner even if they are from same source. We Need to check the sorted input property in joiner.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Explain difference between data ware house & data mart?
What is the difference between Datawarehouse and OLAP?
What is MODEL is Data mining world?
Briefly state different between data ware house & data mart?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Can you pass sql queries in filter transformation?
What are session timeout and application timeout?
What is normalization, first normal form, second normal form, third normal form?
explain about balanced dimension,
Can a dimension table contain numeric values?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain meta data?
Explain why are oltp database designs not generally a good idea for a data warehouse?