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
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
how do u implement configuration management in Informatica?
What is tracing level?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Explain etl mapping sheets?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What is full load & incremental or refresh load?
Explain about the data integration suite features?
how do u set partition points in the mapping?
What is staging area referring to?
What is tracing level? How many types of transformations supported by sorted input?
Which transformation we use to convert 'NA' to 'Not Available'
State the differences between shortcut and reusable transformation
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is session partitioning?