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
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Explain about enterprise scalability and roi of data integration suite?
What are the various tools used in etl?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
what is the difference steps for data modeling?
what is Forward,Reverse and Re_engineering?
what is dynamic insert?
what are Lookup caches options? Including persistent caches.
Explain me ETL project architecture in Detail?
Explain about etl data integration software?
how do u really know that paging to disk is happening while u are using a lookup transform?
State the differences between shortcut and reusable transformation
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
how would u estimate the size of Lookup transform data and index cache?
what are the data modeling tools you have used?(polaris)