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 |
Can we call a stored procedure from a unix script which is run using command task
what is filelist concept in informatica
What are the components of workflow manager?
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
why we use informatica in our project?
what is the difference between Informatica 7.1 and Abinitio?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
What is the status code?
Do you find any difficulty while working with flat files as source and target?
Please let me know how to make encryption and decryption with example?