Answer Posted / sanjay

Target option for flie: FTP, LOADER, MQ
For Relational : Oracle, Teradata, sybase, Informix etc.

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

1122

---

How to create or import flat file definition in to the warehouse designer?

1062

---

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

1944

---

What are the restrictions of union transformation?

1020

---

Briefly define a session task?

1109

---

How do you use reject loader.

2589

---

What is a mapplet/worklet in informatica?

1174

---

Can we get 1st record through Informatica(without sequence number).

1463

---

Explain the types of transformations?

1052

---

Explain the mapping variable usage example in informatica

1138

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1044

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2086

---

What are connected or unconnected transformations?

1102

---

Enlist the differences between database and data warehouse.

1103

---

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

4132

---