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

scenario where i can use only concurrent execution of workflow.

3093

---

How to use procedural logic inside infromatica?

1158

---

What is meant by lookup transformation? Explain the types of lookup transformation?

910

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1074

---

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

1029

---

What is Data Caches size?

1053

---

What is Cognos script editor?

4182

---

Reusable transformation and shortcut differences

1799

---

Explain the use of aggregator cache file?

1205

---

What is a shortcut and copy in Informatica and how two are different with each other?

1156

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1245

---

What's the layout of parameter file (what does a parameter file contain?)?

2351

---

What is the command used to run a batch?

1016

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

994

---

Explain the mapping variable usage example in informatica

1108

---