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
- 4867 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 is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
Why we select the table which has minimum number of records as Master table in joiner?
What are the advantages of informatica?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
what is distinct
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
What is workflow manager?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
What is aggregate cache in aggregator transformation?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
What is the Rank index port in Rank transformation?
What is a sorter transformation?
Teradata 
