Answer / teja_dwh

the file has to be exist in your machine.then import file same
as database table.to import specify the path.

Answer / immu

Source Analyzer---->click on import from file---->select file

explain about unit testing? in real time?

0 Answers   L&T,

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

What are Business Components in Informatica?

1 Answers  

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

In any project how many mappings they will use(minimum)?

1 Answers  

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

---

Which transformation should u need while using the cobol sources as source defintions?

2 Answers  

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---