Interested to Buy Any Domain ? << Click Here >> for more details...
one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 7331 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / jay
SQ ---------> UPD --> TRG
| ^
| |
--> LKP --
In update startegy, just give type as formula
iif(isnull(LKP_Col1), 0, 1)
0 --> DD_INSERT
1 -->DD_INSERT
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the difference between a repository server and a powerhouse?
expain about the tune parameters?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is rank transform?
What are the performance considerations when working with aggregator transformation?
What are the different components of powercenter?
What is sorter transformation?
Can we create two repositories on same database instance in oracle?
Explain how to import oracle sequence into informatica?
How to do unit testing in informatica? How to load data in informatica ?
How many ways are there to create ports?
Define enterprise data warehousing?
which one is better performance wise joiner or look up
How to load a Dimension ? and how to load a fact table?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
