Answer / bsgsr

i believe this should work.

1) use the first and last functions of aggregate t/tion.
2) use the top option and 1 rank using rank t/tion
similarly last option and 1 rank to get only the first
and lst records.
3) else connect the flat file to filter t/tion. create new
port in filter name it s_no and connect the nextval port of
s.gen and write the contion (assume the file contains 100
records) like s_no=1 or s_no=100

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

---

what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

what happens when a batch fails?

3 Answers  

---

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

---

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

How do you change a non-reusable transformation to reusable transformation?

0 Answers  

---