Answer / bidhar

First thing to note is that Both the sources must be
Homogeneous.
Also the Order of the ports in SQ and the order of the
Columns in the select query (if you are using SQL override)
must be same.

Answer / krishna

1.two or more relational tables are with primary key-
foreign key relationships by linking the sources to one
Source Qualifier transformation.
2.the data types of the ports must match.

violation of these two conditions may lead to errors while
joining two tables

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

0 Answers  

---

Difference between Target-based loading and constraint-based loading?

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,

---

What are the advantages of informatica?

0 Answers  

---

Why do we use DSS database for OLAP tools?

2 Answers  

---

What is joiner transformation?

0 Answers  

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

Describe an informatica powercenter?

0 Answers  

---

In a sequential batch can you run the session if previous session fails?

4 Answers  

---

Please let me know how to make Data masking in informatica..

0 Answers  

---

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

---

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

---