Interested to Buy Any Domain ? << Click Here >> for more details...
there is a mapping with expression and mapping we create
some condition for insert and update and followed by update
startegy ,can we update and insert on a single target based
on condition?
- 1 Answers
- 4876 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer / gm
Yes, We can do both in Update Startegy,
SOURCE-SQ-EX-LKP-UPD-TAGET
In Update Startegy IIF(ISNULL(EMPID),DD_INSERT,DD_UPDATE)
| Is This Answer Correct ? | 8 Yes | 0 No |
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
What are the restrictions of union transformation?
Mention a few design and development best practices for informatica?
what is DSS?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what are the row and column separations in Flat Files
what is the difference between Informatica7.1 & informatica 8.1
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
How to join three sources using joiner?
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
How can we improve session performance in aggregator transformation?
Teradata 
