Interested to Buy Any Domain ? << Click Here >> for more details...
How do you create single lookup transformation using
multiple tables?
- 6 Answers
- 44643 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / murali vishnuvajhala
you cannot join two tables in a lookup. Lookup works only
on one underlying table.
| Is This Answer Correct ? | 4 Yes | 34 No |
Post New Answer View All Answers
What is a sorter transformation?
How big was your fact table
What is the difference between a repository server and a powerhouse?
Design a mapping to load a target table with the following values from the above source?
State the differences between sql override and lookup override?
Please let me know how to make encryption and decryption with example?
Describe an informatica powercenter?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
According to his methodology what all you need before you build a datawarehouse
Explain lookup transformation source types in informatica
Partition, what happens if the specified key range is shorter and longer
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
How many types of sessions are there in informatica.please explain them?
