Answer Posted / babu

Hi Guys,
small change is there in above solution

i.e:: GRP2:sno<=(cno/2)+2 AND sno>=(cno/2)-2




Cheers,
Babu Rao

Do we need an etl tool?

983

---

what are the types in error loging?

2137

---

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

1785

---

what is Forward,Reverse and Re_engineering?

2231

---

How many types of transformations supported by sorted input?

1199

---

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2210

---

What are the names of the layers in etl?

980

---

how do u set partition points in the mapping?

2227

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2014

---

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2194

---

flat filevalidation in informatica

2129

---

Explain different types of partitioning?

1011

---

What is tracing level and what are the types?

943

---

What is etl process? How many steps etl contains?

1019

---

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

2106

---