Interested to Buy Any Domain ? << Click Here >> for more details...
one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 7221 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 fact table? Explain the different kinds of facts.
What is the use of code page?
Differentiate between a database and data warehouse?
Name the different lookup cache(s)?
How to update a particular record in target with out running whole workflow?
Separate from an archive server and a powerhouse?
What is Data Caches size?
How can you define user defied event?
What is joiner transformation in informatica?
Plz can any one say me how to get the informatica certification materials and dumps
How can we store previous session logs?
What are ETL Tools?
What are the different transaction levels available in transaction control transformation?
How to differentiate between the active and passive transformations?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
