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
- 4375 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 names of the layers in etl?
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
where are the log files generally stored.Can you change the path of the file.what can the path be?
How many steps etl contains explain with example?
What is etl process? How many steps etl contains?
what is the use of server?
if u can't find what you are looking for in lookup table, how do you handle?
what are the different Reporting and ETL tools available in the market?
What are the etl testing operations includes?
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
Teradata 
