How to Check the source record count from traget table.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the types in error loging?

1845


What is data modeling and data mining?

744


What are various etl tools in the market?

729


What is a mapping?

768


What are the steps involved in etl process?

726


What is Data Vault???

2523


where is the cache (lookup, index) created and how can you see it.

1786


Explain about round-robi?

874


Identifying the bottlenecks in various components of Informatica and resolving them.

2391


Explain me ETL project architecture in Detail?

2139


what is the difference between cardinality and Nullability?

2729


State the differences between shortcut and reusable transformation

752


Which transformation we use to convert 'NA' to 'Not Available'

1054


where we cannot use sorter Transformation. if we use then we will not get correct data?

1997


Can we create Hierarchies in generic datasources?

2121