Interested to Buy Any Domain ? << Click Here >> for more details...
How to compare Source and Target table, without using
dynamic lookup?
- 4 Answers
- 11004 Views
- I also Faced
- E-Mail Answers
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 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
what is a transforamation?
Difference between task flow and linear task flow
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
what is mapping parameter?
Major difference between SQL override and Lookup Sql override
How to load a Dimension ? and how to load a fact table?
Describe two levels in which update strategy transformation sets?
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
Teradata 
