Answer Posted / etl guru

Hey fools, understand the question. The question is "Data
is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?"
The answer is: Mapping is invalid. We can never connect a
data from Active and passive transformation TO A PASSIVE
TRANSFORMATION. Can you connect output of a joiner and
Expression to an expression transformation?

What is depict expression change?

603

---

write a query to retrieve the latest records from the table sorted by version(scd)

625

---

What is the status code in stored procedure transformation?

679

---

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

1906

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

589

---

---

What are the main issues while working with flat files as source and as targets ?

640

---

What is the benefit of partitioning a session?

617

---

How are the sources and targets definitions imported in informatica designer?

662

---

How to join three sources using joiner? Explain though mapping flow.

683

---

What is meant by LDAP users?

684

---

How to elaborate tracing level?

676

---

How do you load only null records into target? Explain through mapping flow.

1488

---

what is informatica metadata?

588

---

How many ways are there to do 'remove duplicate records in informatica'?

574

---

Can we override a native sql query within informatica?

621

---