Answer / sarvesh

in aggregator
data cache size is:
no.of groups(sigma(colomnsize)+7)and same for index
cache also

What do you understand by term role-playing dimension?

0 Answers  

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---

How an expression transformation differs from aggregator transformation?

0 Answers  

---

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

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,

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

---

How to extract original records at one target & Duplicate records at one target?

12 Answers  

---

What are the different caches used in informatica?

3 Answers   UST,

---

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

---