Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?
- 2 Answers
- 8915 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
How do you set a varible in incremental aggregation
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
Scheduling properties,whats the default (sequential)
What is informatica metadata and where is it stored?
where to store informatica rejected data? How to extract the informatica rejected data?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is persistent lookup cache?
How to load data in informatica ?
What are the prerequisite tasks to achieve the session partition?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
how to load dimension table and fact table. plz tell me the steps.
How do you handle two sessions in Informatica
How to open an older version of an object in the workspace?
Can you generate sequence numbers without using the sequence generator transformation?
What are the different clients of powercenter?
