If we have 1000 rows were loaded in to datawarehouse and
next day the source have 1010 rows so, how can we loaded
only updated rows into target.
Answer Posted / aswinigallery@gmail.com
Yes, we can use scd type 1 (only update flow).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x developer?
What are the components of workflow manager?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain what is informatica metadata and where is it stored?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is flashback table ? Advance thanks
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How can we delete duplicate rows from flat files?
What is update strategy transform?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the different options available for update strategy?
What does role playing dimension mean?