Answer Posted / sri47

It Actually depends on the nature of the Column on which
you are goint to create an index.

Bit Map: If the column is of type Flag means contains 1 or
0.
Binary: If the column cintains numerical values.

Partitions also can be created if column values contains
only some list of values .

What is meant by LDAP users?

699

---

What is primary and backup node?

704

---

What is target load order?

810

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1691

---

---

What is an expression transformation in informatica?

519

---

expain about the tune parameters?

1890

---

Enlist few areas or real-time situations where informatica is required.

597

---

Briefly define reusable transformation?

628

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

555

---

What are mapplets? How is it different from a Reusable Transformation?

630

---

What is the status code in stored procedure transformation?

687

---

Explain constraint based loading in informatica

663

---

How to do unit testing in informatica?

725

---

What are the databases that informatica can connect to windows?

587

---