Answer Posted / rahul patil

All the above approaches are not correct because question was to join two flat files... if we use indirect file or unix command or joiner trns, we could only union two files but not join.

If we have file1 --- 100 records and
file2 --- 100 records then through above approaches we would have only 200 records.

But a join without join condition would return cartesian product and in our case count should be 10000.


Rahul Patil
DWHKID

How do you load only null records into target? Explain through mapping flow.

2036

---

Define mapplet?

1019

---

Explain the different lookup methods used in informatica?

1053

---

Which transformation is needed while using the Cobol sources as source definitions?

1181

---

State the differences between sql override and lookup override?

1221

---

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

4170

---

What is decode in static cache?

1194

---

What is a repository manager?

1100

---

Differentiate between sessions and batches?

1027

---

Parameter and variable differences

2070

---

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

1491

---

What is decode in informatica?

1178

---

What are active and passive transformations?

1094

---

How many ways are there to create ports?

1344

---

What is the difference between Active and Passive transformation?

1166

---