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 |
Do we need an etl tool?
What is Relational Integrity?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
What is the difference between round-robin partitioning and hash partitioning?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
what is the difference between cardinality and Nullability?
what is SMP AND MPP?
How we can see table structure?
what are the production issues in datastage?
where we cannot use sorter Transformation. if we use then we will not get correct data?