how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 2852 Views
- QualTech, I also Faced
- E-Mail Answers
Answer Posted / sajj
If source is flat file its aggregator of course but if source RDMS then we preferred to do it database level if possible
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is session partitioning?
where we cannot use sorter Transformation. if we use then we will not get correct data?
how does the server recongnise the source and target databases.Elaborate on this
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is the difference between cardinality and Nullability?
what are Lookup caches options? Including persistent caches.
how would u estimate the size of Lookup transform data and index cache?
How to increase performance without changing anything in mapping.( In prod)
Define slowly changing dimensions (SCD)?
what are the concerns of OLTP and DSS systems?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
What is Data Vault???
What are snapshots?
What are the different Lookup methods used in Informatica?
Give the benefits of data integration suite?
