can we load the data with out a primary key of a table?
what is target plan?
Answer Posted / 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 |
Post New Answer View All Answers
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Which is the t/r that builts only single cache memory?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the different versions of informatica?
r u done any partitions in ur project?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to update a particular record in target with out running whole workflow?
What are the static cache and dynamic cache in informatica?
what is $$$$?
What does refresh system mean, and what are its distinctive choice?
What are the reusable transformations?
What is session task and command task?