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
- 15213 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 |
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How informatica process data means how informatica works?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
What is confirmed dimension?
What are the new features of informatica 9.x at the developer level?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
What are the types of caches in lookup?
I want load the data into target with out 1st and last record.
Differnce between filter and router?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Teradata 
