How to Check the source record count from traget table.
Answer Posted / nani
fire the query on target table.target table minus source table.
u can easily find how many records loaded.
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
What is the difference between Data Warehousing and Data Mining?
what is the difference between cardinality and Nullability?
Explain about power designer data modeling software?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
How to fine tune mappings?
where is the cache (lookup, index) created and how can you see it.
what is the difference between cubes and package in cognos
Mention few test cases and explain them?
When do we analyze the tables? How do we do it?
Is apache nifi an etl tool?
how does the server recongnise the source and target databases.Elaborate on this
if i have a query as flat file how can we load data to target table
How can we use external procedural logic in informatica?
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.
What is initial load and what is full load?