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
Give the benefits of data integration suite?
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
What are three tier systems in etl?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
how would u estimate the size of Lookup transform data and index cache?
how do u extract data from different data sources explain with an example?
What is staging area referring to?
What is data modeling and data mining?
what are the session parameters? How do u set them?
What is a lookup table in etl?
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.
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What do you understand by the term ‘transformation’?
What is a mapping, session, worklet, workflow, mapplet?