How to Check the source record count from traget table.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shyam
You can fire the query based on the timestamp.If the
loading happened today you can give the condition like--
>Sel * from table where date > 'yesterday's_date';
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ravi
hi nani how can we fire query if the environment is
different i mean if my source is teradata and my target is
oracle
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / srinivas
write the source query in target table by using the schema
name.table name.
ex:
select count(*) from src.emp;
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
what are the production issues in datastage?
what is the main role of FI on business
explain the methodology of Data Warehousing?(Polaries)
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
what are the reporting tools and difference between them?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
what is the indicator file and where it is used?
What is Relational Integrity?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
How to Check the source record count from traget table.
Explain about the data integration suite features?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in