Answer / niharika panda

Informatica is an ETL tool used in DWH concept.
It keeps historical data. So all those organizations who wants
to keep their all data i.e. updated and historical too(not
only to update data and deleting the old data) can use it.

Answer / jagadeesh gaddam

Informatica is an etl toll .it loads the data from various oltps like homogenius as well as hetrogeniuse.based on this loadig  data we can genarate the reports what we exactly want for our business development and anyalise the business and take the right decissions 

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

---

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,

---

performance tuning of Informatica

1 Answers  

---

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

What are conformed dimensions?

1 Answers  

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

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

0 Answers  

---

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

1 Answers  

---

how i will stop my workflow after 10 errors

2 Answers   HP,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---