Answer / kishore

b-tree indexes are used usuall when we have too many
distinct columns and for high cardinaties . and bitmap
indexex are used for low cardinaties usually when we have
repeated columns.

Answer / ranvir thakor

WE can use B-Tree index where data cardinality is high and
many DML operations are performed and have many distinct
values. while Bitmap will use when have low cardinality and
less distinct value like gender column(M/F) or value does
not update frequently.

Answer / sarvesh

bit map incdex is an index in which the data will be in the
form of bites,by this we can retrieve the data very fastly
btree index is an index which is default index as
normal indexes.

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

Can you copy the session to a different folder or repository?

2 Answers  

---

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

---

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

---

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

---

---

how to connect two or more table with single source qualifier?

4 Answers   IBM,

---

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

---

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

---

What are the tasks that source qualifier perform?

0 Answers   Informatica,

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

---

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

---

In development project what is the process to follow for an etl developer from day1

0 Answers  

---