Interested to Buy Any Domain ? << Click Here >> for more details...
can we load the data with out a primary key of a table?
what is target plan?
- 6 Answers
- 15162 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh
we can load data without primary key but if whenever u need to update the table from informatica then u have to use update override then only u can update the table.
target plan: if u have maultiple source and multiple targets in one mapping then u have to go target load order this option available in mapping tab
correct me if i wrong
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / guest
yes we can........ dont mention any primary key in target
table. use target load as bulk mode in session and run it..
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sbvp
acutally we need pk for updating records while using update
strategy t/r. if we want load the data into the target with
out pk is possible. while we don't create pk,fk in tgrt
table we will use bulk loading but there is no recovery
option for bulk loading. if u want recovery option for ur
mapping u can use normal trgt load type ok.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / manjunath
Yes, we can load the data without the primary key, but if you want to use furhtet i.e to update we cant do it, for that we need primary key.
Target Load Plan : It is used if we have multiple sources and targets we go for this option (We can have this option in Mapping Tab)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mike
We need a primary key to update a table and an update
strategy transformation with data driven options. Hope this
helps
correct me if i was wrong
| Is This Answer Correct ? | 1 Yes | 2 No |
how i will stop my workflow after 10 errors
What is blocking transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
how remove 1st 3 records & last 3 records in informatics
Why filter transformation is an active one?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
Explain what are the different types of transformation available in informatica.
Enlist few areas or real-time situations where informatica is required.
why do u use shortcuts in informatica.?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
How does the server recognize the source and target databases. Elaborate on this.
Teradata 
