On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
Answer Posted / prasad
use scd3 concept or use scd2 concept
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are the informatica performance improvement tips
tell me about your project functionality
What is a pre-defined event and user-defined event?
What are the different clients of powercenter?
What is the session task and command task?
Whats there in global repository
What are mapplets?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is an aggregator transformation?
How to implement security measures using repository manager?
How an expression transformation differs from aggregator transformation?
Name the different lookup cache(s)?
Global and Local shortcuts. Advantages.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?