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
- 14952 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 |
Can you generate sequence numbers without using the sequence generator transformation?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
What is the reusable transformation?
What is the function of union transformation?
Define pmcmd command?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Do you find any difficulty while working with flat files as source and target?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
What is an Integration service in Informatica?
Teradata 
