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
- 2 Answers
- 5750 Views
- HCL, iGate, I also Faced
- E-Mail Answers
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
what is data modeling?
What is Data Vault???
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What are the various tools used in etl?
Explain about the data integration suite features?
Two default user groups created in the repository are____and_____.
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
how do u identify the changed records in operational data?
Explain about round-robi?
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.
In Which Transformation We Can Use Having Clause In Informatica?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
