Answer Posted / itsranjan

Software tools for Datawarehouse:
1)Operating system(Unix or windows)
2)Database(Oracle,DB2 etc.)
3)ETL(Informatica/Abinitio/Datastage/MSBI etc.)
4)Reporting(Business Objects/Cognos/MSBI etc.)
5)Datamodelling(Erwin/Visio etc.)

These are some common softwares i have mentioned.But some
other softwares are also present.

What are the tuning techniques you applied during your last project

1559

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

783

---

How to load the data from people soft hrm to people soft erm using informatica?

558

---

What are batches?

617

---

What is a dimensional model?

581

---

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1866

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2321

---

Explain joiner transformation in informatica

664

---

What is flashback table ? Advance thanks

1478

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1333

---

Why filter transformation is an active one?

561

---

How would you copy the content of one repository to another repository?

549

---

What does role playing dimension mean?

621

---

 Informatica Checkpoints

2853

---

Clarify the utilization of aggregator cache record?

575

---