Answer / suraj kedia

Joiner transformation is used to join source data from two
related heterogeneous sources. However this can also be used
to join data from the same source. Joiner t/r join sources
with at least one matching column. It uses a condition that
matches one or more pair of columns between the 2 sources.
To configure a Joiner t/r various settings that we do
are as below:
1)Master and detail source
2)Type of join
3)Condition of the join

Differentiate between a database and data warehouse?

0 Answers  

---

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---

how to we create datamart?

2 Answers   HSBC,

---

What are the different types of transformation available in informatica.

0 Answers  

---

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---

Whats the difference between $, $$, $$$

9 Answers  

---

What are the types of error logs available in Informatica?

1 Answers  

---

WHat all joins are there in Source Qualifier?

1 Answers  

---

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

---

how to delete duplicate records by using filter transfermation?

3 Answers  

---

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

1 Answers   IBM,

---