Answer Posted / ankit kansal

Overall Desc
SRC-->>SQ-->>EXPR-->>FILTER-->>TARG

create a mapping variable name $$max_bound of integer data type and aggregation type max

now in expression variable
seq v seq+1
o_seq o seq
v_temp v v_temp+1
curr_val v IIF(v_temp=1,setmaxvariable($$max_bound,$$max_bound+2),0)
o_map_val o setvariable($$max_bound,NULL)


now come to filter transformation
and write condition as
(seq<=$$max_bound)AND(seq>$$max_bound-2)

Thanks
http://deepinopensource.blogspot.in/

if i have a query as flat file how can we load data to target table

972

---

What is data modeling and data mining?

554

---

What is a mapping?

558

---

what are Lookup caches options? Including persistent caches.

1442

---

what is an ETL or ETT? And what are the different types?

6922

---

---

What is fact? What are the types of facts?

534

---

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

502

---

dimension object created in oracle can be imported in designer?how?

2453

---

Explain about the data integration suite features?

471

---

how would u estimate the size of Lookup transform data and index cache?

1634

---

Can u access a repository created in previous version of Informatica?

1466

---

what is the use of server?

1735

---

what is session partitioning?

1457

---

Can we create Hierarchies in generic datasources?

1924

---

What is etl process? How many steps etl contains?

591

---