can we load the data with out a primary key of a table?
what is target plan?
Answer Posted / 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 |
Post New Answer View All Answers
How to load the data from people soft hrm to people soft erm using informatica?
What is workflow? What are the components of workflow manager?
What is the maplet?
Explain your project of banking domian.
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is a transaction control transformation?
what are 3 tech challenges/ common issues you face?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How union transformation is used?
What is rank transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
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.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
design of staging area?
According to his methodology what all you need before you build a datawarehouse