Answer / guest

we can not have flat override in any of the Transormation.
We have only sql query here we can use the custom query for
relational sources and we have lookup override is there
here we can sql query for relational sources suppose we
going to lookup on relational table.

What is a dimensional model?

0 Answers  

---

what we require for D.modelling?

1 Answers  

---

What is a node in Informatica?

0 Answers  

---

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

0 Answers   Cognizant, IBM,

---

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

What is incremental aggregation?

0 Answers  

---

What is union transformation in informatica?

0 Answers  

---

What is a difference between complete, stop and abort?

0 Answers  

---

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

---

Describe data concatenation?

0 Answers  

---

Explain what are the different types of transformation available in informatica.

0 Answers  

---