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
- 4309 Views
- I also Faced
- E-Mail Answers
Answer / chintan thakkar
It should always be done at SQ level, that will improve the performance of the mapping since informatica stores a cache for aggregator transformation.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
what is data modeling?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
SCD2 will work on only dimension tables as well as fact Table?
How many steps etl contains explain with example?
what are the facilities provided by data warehouse to analytical users?
What is the difference between round-robin partitioning and hash partitioning?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
when will use SQL override in a lookup transformation?
what are variable ports and list two situations when they can be used?
how do u extract data from different data sources explain with an example?
Identifying the bottlenecks in various components of Informatica and resolving them.
Teradata 
