Answer / kunkala ramakrishna

both the file and table metadata should same then we can join

Answer / surya

You can connect heterogeneous sources to a Union transformation.The transformation merges sources with matching ports and outputs the data from one output group with the same ports as the input groups

Diffrence between static and dynamic cache

2 Answers   HCL,

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

---

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

---

What is sq transformation?

0 Answers  

---

Differentiate between joiner and lookup transformation?

0 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

How can we create index after completion of load process?

0 Answers  

---

What is hash partition?

1 Answers  

---

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

What is meant by lookup transformation?

0 Answers  

---