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 / babu
By selecting 'UPDATE else insert' in the 'Treat source rows
as :'from
session properties we can get updated rows and new rows..
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
Differentiate between reusable transformation and mapplet.
What is rank transform?
What is meant by LDAP users?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain the etl program with few examples.
What is the need of an ETL tool?
How many ways a relational source definition can be updated and what are they?
EXL informatica Questions
expain about the tune parameters?
what is SDLC way of code development?
What do you mean by enterprise data warehousing?
What is rank index in rank transformation?
What is the function of union transformation?