How to compare Source and Target table, without using
dynamic lookup?
Answer Posted / 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 |
Post New Answer View All Answers
What is source qualifier transformation in informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is dynamic cache?
Separate from a database, an information bazaar, and an information stockroom?
Explain the informatica workflow?
How can you validate all mappings in the repository simultaneously?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a joiner transformation and why it is an active one?
In how many ways we can create ports?
How many ways are there to create ports?
explain abt ur project architecture?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What do mean by local and global repository?