Interested to Buy Any Domain ? << Click Here >> for more details...
what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
- 6 Answers
- 14282 Views
- I also Faced
- E-Mail Answers
Post New Answer View All Answers
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
Can we override a native sql query within informatica?
What is the function of aggregator transformation?
How to elaborate powercenter integration service?
Write the unconnected lookup syntax and how to return more than one column.
What are the different clients of powercenter?
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?
What is an active transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain about cumulative Sum or moving sum?
Write the advantages of partitioning a session?
what is index?how it can work in informatica
What is meant by query override?
While migrating the data from one environment to another environment how would you manage the connections?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
