Interested to Buy Any Domain ? << Click Here >> for more details...
How to Check the source record count from traget table.
- 5 Answers
- 14185 Views
- IBM, I also Faced
- E-Mail Answers
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 |
how would u estimate the size of Lookup transform data and index cache?
State the differences between shortcut and reusable transformation
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
How many steps etl contains explain with example?
what is the advantage of persistent cache? when it should be used?
What is staging area referring to?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Is hadoop a etl tool?
what are the production issues in datastage?
What is lookup table in etl testing?
Which type or t/s is used to convert rows into column & column into rows
What are the three tiers in etl?
Teradata 
