Answer Posted / anitha

scds are three types.
type1:it stores the current data.

type2:it stores the full historical data.

type3:it stores the current and previous data in the target...

Define pmcmd command?

1103

---

What is enterprise data warehousing?

1104

---

Difference between Target-based loading and constraint-based loading?

1042

---

What is resilience time?

1221

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

2006

---

Write the program through which the records can be updated?

1053

---

Explain scd type 3 through mapping.

1051

---

Explain the different dimensions.

1004

---

differences between service based and product based?

2058

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2899

---

What is different between the data warehouse and data mart?

1111

---

State the limitations where we cannot use joiner in the mapping pipeline?

1105

---

What is a code page?

1217

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2150

---

What are the differences between source qualifier and joiner transformation?

1133

---