can we load the data with out a primary key of a table?
what is target plan?

Answer Posted / koti

by using update overide option we can update the target
though we dont have any primary key in target.

target overload means some time in a single mapping no. of
targets can take place one source can be depend on other
target. then we have to decide which target has to execute
first....
ex: source1.... target1(date of birth is one column in
target 1)

source2(age is one column is source2).... target2

in the above example target1 should be execute first. then
only we can get age in source 2. because age is depends on
date of birth which is available is target1...
hope u understood. if any clarification mail to me:
manjulakoteswararao@gmail.com

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1650


What is the Rank index port in Rank transformation?

672


What are the reusable transformations?

703


Explain your project of banking domian.

1220


How can we store previous session logs?

569






What is informatica etl tool?

556


write a query to retrieve the latest records from the table sorted by version(scd)

635


How to do the error handling of if ur source is flatfiles?

1515


Describe data concatenation?

576


What is the difference between Active and Passive transformation?

639


What does update strategy mean, and what are the different option of it?

590


Tell me about MD5 functions in informatica

528


Enlist the advantages of informatica.

632


What are the various types of transformation?

646


How are the sources and targets definitions imported in informatica designer?

672