Interested to Buy Any Domain ? << Click Here >> for more details...
i have two source data there is no pk,fk how to join the
two sources
- 5 Answers
- 11388 Views
- TetraSoft, I also Faced
- E-Mail Answers
Answer Posted / tauseef
if the two sources or coming from same datasource then we
can use source Qualifier trans to join
if it is coming from different then same add a dummy port on both the tables and join
if its wrong send me the soulution to my id tauseefwst@yahoo.com
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is joiner change?
Design a mapping to load a target table with the following values from the above source?
What is the scenario which compels informatica server to reject files?
What are the types of presistent cache in look up tr.
Explain the code page compatibility?
Mention few advantages of router transformation over filter transformation.
What is Cognos script editor?
Reusable transformation and shortcut differences
Separate from an archive server and a powerhouse?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can we get 1st record through Informatica(without sequence number).
What are pre and post-session shell commands?
What could be the possible resons of locks by user?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is different between the data warehouse and data mart?
