How to Check the source record count from traget table.
Answer Posted / eswar
It's not possible to find count of source table records through target table if both databases are different.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain what are the various etl tools in the market?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Explain etl?
what is Forward,Reverse and Re_engineering?
What is tracing level?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
How etl testing is different from database testing?
Can there be sub steps of etl steps?
What is tracing level? How many types of transformations supported by sorted input?
what is the difference between cubes and package in cognos
List few etl bugs?
what is the difference between cardinality and Nullability?
What is initial load and what is full load?
Mention few test cases and explain them?
Explain about enterprise scalability and roi of data integration suite?