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 |
need for registering a repository server
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to do Integration testing in Informatica?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
Two Default User groups created in the repository are ____ and ______
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How does a rank transform differ from aggregator transform functions max and min?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,