Answer Posted / shiva

understanding the transfromatin language,and analize the
tranfromation language time being taken to achieve the
taske ,then push the trasnformtin logic either source
database or targer database.

Performance tuning( what you did in performance tuning)

1975

---

Explain in detail scd type 2 through mapping.

1039

---

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

1956

---

Explain the different dimensions.

956

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7442

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1106

---

Explain transaction control transformation in informatica

1263

---

Which transformation should we use to normalise the COBOL and relational sources?

1199

---

What are the different ways to implement parallel processing in informatica?

1423

---

Define update strategy?

1214

---

How would you copy the content of one repository to another repository?

1014

---

Which are the different editions of informatica powercenter that are available?

1031

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2352

---

What are the differences between source qualifier and joiner transformation?

1054

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4157

---