Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 96365 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
hi, everyone.
lookup is passive whereas is joiner is active.
look up supports non equi joins ilso whereas joiner
supports only equi joins.
lookup joins on either on first value or last value.
lookup uses dynamic and static cache where as a joiner
doesnt
reach me on bsrinivas1213@gmail.com
| Is This Answer Correct ? | 22 Yes | 11 No |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
what is the size of u r source(like file or table)?
Explain what is informatica metadata and where is it stored?
What is workflow manager?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain the types of lookup transformation?
Define pmcmd command?
What is a rank transform?
Explain the different lookup methods used in informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
can u give example for factless fact table
What is meant by a domain?
What is a repository? And how to add it in an informatica client?
What are the main features of Oracle 8i with context to datawarehouse?
