Answer / Dharmandra Datt Yadav

Yes, you can read MS Excel data directly into Informatica by using the Microsoft Excel Connector.

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

Make a note of the quantity vaults made in informatica?

1 Answers  

---

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

---

what are surrogate keys?

5 Answers  

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1 Answers  

---

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

---

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

---

why we are using surogate key in real time give me explanation

2 Answers   TCS,

---

What is Cognos script editor?

1 Answers   Cognizant,

---

What is the need of an ETL tool?

1 Answers   Informatica,

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---