1. if lookup tr is giving poor performamence. what u do.
2. i have emp,dept table. i want output
ename,empno,dname,max(sal).
3. can any one tell me project flow in real time scenario.
please send me mail any queries and answers
my mail id is yaparala@gmail.com
Answer Posted / reddy guru
According to my knowledge write a query inlookup query
override or increase the cache size
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we create Hierarchies in generic datasources?
Explain about round-robi?
Define slowly changing dimensions (SCD)?
how to load the data to fact table?
how do u handle performance issues in Informatica . where can u monitor the performance ?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
How many steps etl contains explain with example?
what is dynamic insert?
what is a worklet?
how do u really know that paging to disk is happening while u are using a lookup transform?
what are the reporting tools and difference between them?
What are the differences between sql override and update override?
what is pmrep command?
How to increase performance without changing anything in mapping.( In prod)
how does the server recongnise the source and target databases.Elaborate on this