How to generate sequence numbers?

0 Answers  

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

---

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

---

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

what is threshold error in informatica?

1 Answers   TCS, Wipro,

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

---

Define maping and sessions?

3 Answers  

---

What does role playing dimension mean?

0 Answers  

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---