Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6905 Views
- HCL, iGate, I also Faced
- E-Mail Answers
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 |
how do u implement unconn.stored proc. in a mapping?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
when should one create lookup transformation ?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
What is ROWID explain ?
Difference between flat files and relational sources?
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What is full load & incremental or refresh load?
how do use session mapping parameters ?(in which transformation)
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks
Teradata 
