Answer / palthepu_santosh

from source qualifier map the column(id) into two fields of
rank (id,id_grp). select grp_id as group by and rank as 1
output should be
1
2
3

Answer / gyana

after source qualifier take a rank t/r
set the group by as column_id and in rank property set
# the number of rank=1
after that connect to target .you can get the desired result

SOURCE---->SQ--->RANK T/R----->TARGET

Answer / redflower

src->sq->aggregator->filter->target

from aggt/r we would calculate count(empid)
for eliminating duplicates we will write the filter condition
count(empid)=1

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

---

In which scenario did you used pushdown optimization?

1 Answers  

---

What is the function of aggregator transformation?

0 Answers  

---

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

---

Define the various join types of joiner transformation?

0 Answers  

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

---

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---