How You Pull the records on daily basis into your ETL Server.

2 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,

---

who to split dimentions into sub dimention

3 Answers   Wipro,

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

What is source qualifier transformation?

1 Answers  

---

Can you create a flatfile target

3 Answers   ABC,

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

---

What are the rank caches?

2 Answers   Informatica,

---

update strategy transformation in informatica

0 Answers   Informatica,

---

How do you load first and last records into target table?

0 Answers  

---