Interested to Buy Any Domain ? << Click Here >> for more details...
How to Check the source record count from traget table.
- 5 Answers
- 14450 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 to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
How to Check the source record count from traget table.
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
what happens if the info.server doesn't find the session parameter in the parameter file?
What is data modeling and data mining?
Explain about power designer data modeling software?
what is session partitioning?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
how do use session mapping parameters ?(in which transformation)
how does the server recongnise the source and target databases.Elaborate on this
what are the data modeling tools you have used?(polaris)
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
Teradata 
