How to compare Source and Target table, without using
dynamic lookup?
- 4 Answers
- 9651 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagaraju bhatraju
YOu can join the Source and target columns at the source
qualifer level,if you have public synonym on the target, so
that the table can be accessed from all the schemas.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / davan
Am not sure ..default join of look is left out join
so...use of joiner t/r with left outer join..we have to
look up.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to differentiate between the active and passive transformations?
why union is active transformation?
What are the types of presistent cache in look up tr.
What are the various types of transformation?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
How do you join more than 3 flat files in informatica?
What are the Differences between connected and unconnected lookup?
What you know about transaction control transformation?
what is the difference between Informatica 7.1 and Abinitio?
 Informatica Checkpoints
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
Teradata 
