Answer Posted / sanjay gupta

Normally we use two types of indexes in informatica.
Btree Index
Bitmap Index

Bitmap Index gives better performance than Btree Index.

Reusable transformation and shortcut differences

1884

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2049

---

Separate from a database, an information bazaar, and an information stockroom?

1131

---

difference between informatica 8.1.1 and 8.6

3732

---

Partition, what happens if the specified key range is shorter and longer

2557

---

Quickly characterize reusable change?

1185

---

Different circumstance which drives informatica server to expel records?

1043

---

What is the Rank index port in Rank transformation?

1103

---

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?

1231

---

Explain how many types of dimensions are available in informatica?

1173

---

What is depict expression change?

1197

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1383

---

Where is metadata stored?

1195

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4252

---

If informatica has its scheduler why using third party scheduler?

1310

---