Interested to Buy Any Domain ? << Click Here >> for more details...
surrogate keys usage in Oracle and Informatica?
- 5 Answers
- 15755 Views
- ITC Infotech, Oracle, I also Faced
- E-Mail Answers
Answer Posted / tanmoy
A surrogate key is the substitution of natural primary key
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What are the limitations of joiner transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What does update strategy mean, and what are the different option of it?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the meaning of up gradation of repository?
What is olap (on-line analytical processing?
How do we call shell scripts from informatica?
How to update source definition?
What is the format of informatica objects in a repository?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
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 can we do to improve the performance of informatica aggregator transformation?
