Interested to Buy Any Domain ? << Click Here >> for more details...
one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 7162 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
Name the different lookup cache(s)?
What is primary and backup node?
How does a rank transform differ from aggregator transform functions max and min?
Differentiate between router and filter transformation?
Is there any way to read the ms excel datas directly into informatica?
How does the aggregator transformation handle null values?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the different lookup cache(s)?
What is informatica etl tool?
Which are the different editions of informatica powercenter that are available?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are batches?
Reusable transformation and shortcut differences
