How to compare Source and Target table, without using
dynamic lookup?
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 |
What is the Difference between SetVariable and setmaxvariable in informatica?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
Informatica settings are available in which file?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
Explain about Informatica server process that how it works relates to mapping variables?
Can you create a flatfile target
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
what is row level and column level indicator?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Define Update Override?