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
- 4317 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 |
What are the options in the target session of update strategy transsformatioin?
hw cn v elimate dublicate values from lookup without overriding sql?
How to generate a single mapping for both the historical and incremental load.
What is a unit Testing?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
What is domain and gateway node?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can we create index after completion of load process?
how will compare two mappings in two different repository?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
Teradata 
