Answer Posted / babu

Hi,


SRC-->SQ(ENABLE DISTINCT )-->EXP-->TRG

OR
IN EXP T/R TAKE 4 VARIABLE PORTS AND OUTPUT PORT,
SRC HAVEING THE COLUMNS LIKE COL1,COL2,COL3
SRC-->SQ-->SRT(PLEASE TAKE ALL ARE KEY PORTS)-->EXP
(VAR IS IIF(VAR1=COL1 AND VAR2=COL2 AND
VAR3=COL3),1,0)
VAR1=COL1
VAR2=COL2
VAR3=COL3
OUT=VAR
-->UPD(IIF(OUT=1,DD_REJECT,DD_INSERT))-->TRG

IF ANY THING WRONG PLEASE LET ME KNOW.
8861145051

where to store informatica rejected data? How to extract the informatica rejected data?

597

---

What is a transaction control transformation?

761

---

How does a sorter cache works?

563

---

Mention a few design and development best practices for informatica?

555

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1695

---

---

During the running session, output files are created by informatica server. Enlist few of them.

537

---

Explain how to import oracle sequence into informatica?

586

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7666

---

Explain the types of transformations?

591

---

Where do we use mapping variables in informatica?

611

---

Explain constraint based loading in informatica

655

---

What is difference between a gateway node and worker node?

615

---

What is meant by LDAP users?

687

---

What do you understand by SOA of Informatica?

583

---

Different sorts of metadata that stores in the storage facility?

552

---