Answer Posted / aakansha

It is not possible to join a flat file and relational source
without joiner/lookup. Source qualifier is used for
heterogeneous source...means source belongs to same
database...in the ur case flat file and relational source
not belong to same database so...we cant join it into SQ.

What is expression transformation?

1034

---

What is the difference between a connected look up and unconnected lookup?

910

---

Can we create multiple integration service on single repository?

1133

---

What is the command used to run a batch?

994

---

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

944

---

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

4068

---

What is a grid in Informatica?

999

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2468

---

What is dimensional table?

1002

---

What is joiner transformation in informatica?

993

---

What are the types of schemas we have in data warehouse and what are the difference between them?

888

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1604

---

Explain target update override in informatica

1043

---

Under which circumstances, informatica server creates reject files?

1026

---

How to open an older version of an object in the workspace?

1127

---