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 |
Briefly define a session task?
complex mapping ur project u r invlve can u explain and give real time example give me ?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
Describe data concatenation?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
What are two types of processes that informatica runs the session?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
What are the joiner caches?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
tell me the informatica architecture
How many numbers of sessions can one group in batches?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.