2,can we insert duplicate data with dynamic look up cache,if
yes than why and if no why?
Answer Posted / sehaj
DUPLICATE DATA CANOT B INSERTED USIN DYNAMIC LOOK UP
CACHE..BCOZ DYNAMIC LOOK UP CACHE PERFORMS ONLY UPDATE N
INSERT FUNCTION BASED ON THE KEYS IT GETS IN THE TARGET
TABLE N LOOK UP TABLE...
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Can u generate reports in Informatica?
How would you join a node to the already existing domain?
What is a sequence generator transformation?
server hot-ws270 is connect to Repository B. What does it mean?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Which are the different editions of informatica powercenter that are available?
How many ways a relational source definition can be updated and what are they?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
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
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is rank transformation in informatica
my source is junk data how will u remove that junk data by using unix please any one replay me
difference between repository database and repository service?
What is the maplet?