Interested to Buy Any Domain ? << Click Here >> for more details...
How to Check the source record count from traget table.
- 5 Answers
- 14298 Views
- IBM, I also Faced
- E-Mail Answers
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
what is the use of server?
Can u access a repository created in previous version of Informatica?
What is tracing level? How many types of transformations supported by sorted input?
What do you understand by active and passive transformations?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what is the main role of FI on business
how do u really know that paging to disk is happening while u are using a lookup transform?
What is etl process? How many steps etl contains?
how do u really know that paging to disk is happening while u are using a lookup transform?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
What is full load & incremental or refresh load?
What is etl process?
how do u extract data from different data sources explain with an example?
Give the benefits of data integration suite?
what are Lookup caches options? Including persistent caches.
