Answer / lisa

I can add one dummy column to both the tables with value '1' and join both the tables on the basis of that dummy column. But how to do the join when there are huge number of columns/huge data volume in the tables? Please reply!

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

---

How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

What if the source is a flat-file?

0 Answers  

---

What is repository manager?

0 Answers  

---

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

---

Write the different tools in the workflow manager?

0 Answers  

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

What are the types of data warehouses?

0 Answers   Informatica,

---

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

what is target update override and when we use it?

2 Answers   TCS,

---