Interested to Buy Any Domain ? << Click Here >> for more details...
can v update d records in target using update stargey
without generationg primary key ? explain
- 4 Answers
- 16885 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / leo gilbert
By using "Update override" option in the target. Say the
key of your table is ID,NAME. But your mapping is passing
only ID to the target then you can have an update override
query in the target to update the target only based on
ID.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explain transaction control transformation in informatica
Explain Dataware house architecture .how data flow from intial to end?
How to open an older version of an object in the workspace?
What is the sequence generator transformation in informatica?
Define enterprise data warehousing?
How do you set a varible in incremental aggregation
how many types of dimensions are available in informatica?
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 ?
is it possible to index the data in cache of lkp transformation ?
What is event and what are the tasks related to it?
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?
Separate from a database, an information bazaar, and an information stockroom?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Enlist the differences between database and data warehouse.
What are the differences between source qualifier and joiner transformation?
