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

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2169

---

State the differences between sql override and lookup override?

1283

---

Briefly define reusable transformation?

1180

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2310

---

Enlist some properties of sessions.

1135

---

Sequence generator, when you move from develoment to production how will you reset

2122

---

How many input parameters can exist in an unconnected lookup?

1600

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1111

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10318

---

 Informatica Checkpoints

3376

---

without table how to come first record only in oracle?

2301

---

What are the different clients of powercenter?

1114

---

What is pmcmd command?

1179

---

Where can we find the throughput option in informatica?

1107

---

What if the source is a flat-file?

1167

---