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
- 14886 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 to load the data from people soft hrm to people soft erm using informatica?
How to get EVEN & ODD numbers separately?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
Why is meant by direct and indirect loading options in sessions?
what are the settiings that u use to cofigure the joiner transformation?
What are the types of metadata that stores in repository?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
Explain in detail about scd type 1 through mapping.
Tell me about MD5 functions in informatica
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
Explain what is informatica metadata and where is it stored?
Teradata 
