Answer / abhinaw prakash

When we want to Update the Target without any Primary key
but with matching columns then we ll go for Target update
override.
The Integration service outputs a Default query,we need to
make the changes according to the column we want to Update.

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

---

What is metadata reporter?

1 Answers   Informatica,

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

---

What is a filter transformation and why it is an active one?

1 Answers  

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

What is the difference b/w natural key and surrogate key

1 Answers  

---

Define sessions in informatica etl?

1 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---