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
Mention few power centre client applications with their basic purpose?
Can we override a native sql query within informatica?
How to extract the informatica rejected data?
How to generate sequence numbers using expression transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Describe data concatenation?
What is sequence generator transformation in informatica?
How do you load only null records into target? Explain through mapping flow.
What is the way to execute pl/sql script using informatica mapping?
How would you join a node to the already existing domain?
What are roles and groups and benefits of using them?
What can we do to improve the performance of informatica aggregator transformation?
How to do unit testing in informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?