Answer / lahari

There are multiple ways to do it.
1.if source is RDBMS then we can filter by selecting distinct option.
2.In sorter transformation select distinct.
3.In Aggregator transformation select all ports as group by key.

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

---

How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  

---

How will the document be delivered to me?

0 Answers  

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

How do you load only null records into target?

0 Answers  

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---

What is depict expression change?

0 Answers  

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---

What is the need of an ETL tool?

0 Answers   Informatica,

---

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

---