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 |
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What is ROWID explain ?
What do you understand by the term ‘transformation’?
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
What are various etl tools in the market?
Two default user groups created in the repository are____and_____.
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
What are snapshots?
What is cube grouping?
How many steps etl contains?
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
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,