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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sandhya
Hi,
i dont know wether this is write or wrong .but in my way in look up we r having 2 modes cache &noncachemode noncache mode is low performance than the cachemode .bcz look up will maintains the connection with lookup table until comparision is completed.in cache mode lookup table data loaded into memory &dis connected from the lookup table this gives high performance
by using joins we can get the results as of my knowledge
Is This Answer Correct ? | 0 Yes | 4 No |
What are various etl tools in the market?
How many steps etl contains explain with example?
what is the difference between shortcut of an object and copy of an object? compare them?
how many steps are there in etl process?
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 to know informatica conslole password??
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
what are the types in error loging?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record