Interested to Buy Any Domain ? << Click Here >> for more details...
which is better perfomancewise lookup or joiner and why?can anyone give example?
- 6 Answers
- 12071 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / lokesh.t
lookup is having multiple advantages compare to joiner
transformations :-it will avoid duplicate vlues . by
using first last value in lkp values . with lkp we can n
nnumber of tables. where as in joiner we can join only
two tables
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Differentiate between a database and data warehouse?
What is union transformation in informatica?
What are the different lookup cache(s)?
What is the difference between informatica 7.0 and 8.0?
Explain the informatica workflow?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Where can we find the throughput option in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are junk dimensions?
What is aggregator transformation in informatica?
What are the measure objects?
Do you find any difficulty while working with flat files as source and target?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
