Answer / dev

v_filter and v_min_filter
are the variable port how these port come to filter
transformation by which u will compair it on filter
transformation plez check it i need ur help and send me at
hotadebadatta2008@gmail.com

Answer / 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/

Answer / naveen

You are right , this can be achieved only with the help of
the mapping variable. and also a filter transformation

1) create a mapping variable and assign a default value 0
2)during the first run , i hope ur source must have an seq
num in it, if not use the seq gen and have unique sorted
record.
3)in a n expression , just have v_max_filter =
@@map_variable + 2 and v_min_filter = @@map_variable - 2

4) in the filter transformation , put the filter on the
seq_column <= v_filter and seq_column >= v_min_filter

5) enjoy a coffe, this will run

When do we analyze the tables?

0 Answers  

---

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,

---

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

0 Answers   Cap Gemini,

---

Hi, Lookup() is what kind of join ?

6 Answers   Satyam,

---

what are the different Reporting and ETL tools available in the market?

3 Answers  

---

---

what is the difference between OLTP database and data warehousing database?

3 Answers  

---

When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 Answers  

---

Eliminating of duplicate records without using dynamic lookups

3 Answers  

---

What is partitioning? Explain different types of partitioning?

0 Answers  

---

What are the differences between sql override and update override?

0 Answers  

---

you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 Answers  

---