Answer / sumankumar

type2 scd it wil maintain historical informtion + currnt
information along with 3 options .....
1.effective date
2.version number
3.flag value

Answer / chaitanya

Using SCD2 mapping Target warehouse can store recent data+ complete historical data

Type2 dimension mapping or SCD2 mapping can be implemented in 4 ways: i)Limited number of Histories
ii)Star Schema support implementation
iii)Unlimited number of Histories
iv)Unconnected Stored Procedure

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

What are some examples of informatica etl programs?

0 Answers  

---

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

---

What is the Difference between DSS & OLTP?

5 Answers  

---

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

---

How is Data Models Used in Practice?

1 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

0 Answers   IBM,

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

---

what is the difference between mapplet & stored procedure?

1 Answers  

---