Interested to Buy Any Domain ? << Click Here >> for more details...
how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 3156 Views
- QualTech, I also Faced
- E-Mail Answers
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 grain of fact?
Can u access a repository created in previous version of Informatica?
Explain different types of partitioning?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What are cubes and olap cubes?
How to fine tune mappings?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Need Informatica Power Center 9.1 free download(for all windows version)
Explain what are the various etl tools in the market?
Difference between flat files and relational sources?
What are dimensions?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
Teradata 
