Answer / pawan

Number of reasons can be there:
1. Session Impacts.Its not saved properly.
2. Integration service is not correctly mapped.
3. Connection missing in between source & source Qualifier.
4. Parameter file path is not correctly mentioned.
5. Date conversion is not correctly done.etc.

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

---

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

---

what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,

---

How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

What is meant by incremental aggregation?

0 Answers  

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

Can we get 1st record through Informatica(without sequence number).

0 Answers  

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

How can you access the remote source into your session?

1 Answers  

---