Answer / suresh

2008

where actually the usage of push down optimization happens...

2 Answers  

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

---

WHat all joins are there in Source Qualifier?

1 Answers  

---

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

---

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?

4 Answers   ABC, Cap Gemini,

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

Is it possible to revert a global repository to local one and why?

0 Answers  

---

 Informatica Checkpoints

0 Answers   DELL,

---