Answer / ravi

There are two methods:-
1) You can make entry in file Parametrization.
2)Edit task>component>make task on sucess email type as non-
resuable and type your email id over there.

Answer / gazulas

hmm...

session---------->email_task

in the link write a condition "if tgtsuccessrows < 1"


automatically an email will be kicked off...

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

What is an Integration service in Informatica?

0 Answers  

---

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

---

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

Why update strategy and union transformations are active?

0 Answers  

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 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,

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

Can you start a batches with in a batch?

1 Answers  

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---