What is a diff between joiner and lookup transformation
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
Differentiate between joiner and lookup transformation?
What are the different clients of powercenter?
What is dimensional table? Explain the different dimensions.
What is meant by target load plan?
What is data caches/ index caches?
What is data transformation manager process?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What's the layout of parameter file (what does a parameter file contain?)?
How do you take back up of repository?
What are pre and post-session shell commands?
What is a repository? And how to add it in an informatica client?
What is union transformation in informatica?
How might one distinguish in the case of mapping is right or not without associating session?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Slowly changing dimensions, types and where will you use them