how do u decide whether u need to do aggregations at
database level or at Informatica level?
Answer / 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 |
what is a worklet?
what are the different Reporting and ETL tools available in the market?
what is the difference steps for data modeling?
What is partitioning? Explain about round-robin, hash partitioning.
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?
What is the difference between round-robin partitioning and hash partitioning?
What are the names of the layers in etl?
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
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 extract data from different data sources explain with an example?
Eliminating of duplicate records without using dynamic lookups
how do u really know that paging to disk is happening while u are using a lookup transform?