ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
   
 
Categories  >>  Software  >>  Data Warehouse  >>  ETL
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
How to Check the source record count from traget table.
 Question Submitted By :: Stars_guru
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to Check the source record count from traget table.
Answer
# 1
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 4 No
Nani
 
  Re: How to Check the source record count from traget table.
Answer
# 2
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 ?    0 Yes 1 No
Shyam
 
 
 
  Re: How to Check the source record count from traget table.
Answer
# 3
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
Ravi
 
  Re: How to Check the source record count from traget table.
Answer
# 4
It's not possible to find count of source table records through target table if both databases are different. 
Is This Answer Correct ?    1 Yes 0 No
Eswar
 
  Re: How to Check the source record count from traget table.
Answer
# 5
write the source query in target table by using the schema
name.table name.
ex:
select count(*) from src.emp;
 
Is This Answer Correct ?    0 Yes 0 No
Srinivas
 

 
 
 
Other ETL Interview Questions
 
  Question Asked @ Answers
 
how do u set the size of block buffer?  1
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??  1
Identifying the bottlenecks in various components of Informatica and resolving them.  2
what is the meant by Normalization and de-normalization?  2
what is the indicator file and where it is used?  1
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way  2
what are the different forms of normalization?  2
Eliminating of duplicate records without using dynamic lookups  1
what is HISTOGRAM? how to generate statistics?  1
what is session partitioning?  1
what are the facilities provided by OLAP to analytical users?  1
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).  1
 
For more ETL Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com