Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 12911 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasad
use scd3 concept or use scd2 concept
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is exclusive and normal mode for repository services?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is transformation?
What is standalone command task?
What is the need for an etl tool?
what are the deliverables?in your project?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Enlist few areas or real-time situations where informatica is required.
What is main use of mapplet?
expain about the tune parameters?
pmscmd startworkflow -sv
How to update a particular record in target with out running whole workflow?
What is a stored procedure transformation?
what is the size of your data warehousing?
How do you take back up of repository?
