Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?
- 2 Answers
- 9539 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / zak
Yes, we can use Lookup to join 2 tables. Lookup performs
Left Outer Join by default.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
How to do unit testing in informatica? How to load data in informatica ?
How many ways are there to create ports?
Enlist the various types of transformations.
What are the settings that you use to configure the joiner transformation?
Is it possible to use a client with different version than that of its Informatica server?
Differentiate between a repository server and a powerhouse?
list out all the transformations which use cache?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What is a code page?
can u give example for factless fact table
How can you generate reports in informatica?
Explain lookup transformation is active in informatica
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is meant by incremental aggregation?
