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
- 4862 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 |
How many joins in Informatica
Can you generate reports in Informatcia?
What is Collect performance data in informatica and what is the use of it.
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
what is the difference between Informatica 7.1 and Abinitio?
What is confirmed dimension and fact?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
What is confirmed fact in dataware housing?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
What are variable ports and list two situations when they can be used?
Teradata 
