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
How many types of transformations supported by sorted input?
How many steps etl contains explain with example?
Define slowly changing dimensions (SCD)?
Explain the difference between etl tool and olap tools?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
what is the difference between cardinality and Nullability?
What do you understand by the term ‘transformation’?
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.
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
how would u estimate the size of Aggregator transform data and index cache?
What are the key benefits of ETL Testing?
Compare ETL & Manual development?
What is etl process? How many steps etl contains?