Answer / venkat

Use aggregator transformation for getting number of record
count from source.

Answer / nagaraju

count(*) from table;

Answer / saritha

craete a dummy table create table abc(source_name varchar2
(10),count number);

write a sp create or replace prod name

select count(*) into v1 from table name

insert into abc ( 'dvhadvav',v1);
commit;
end

import that sp in the maping and slecte the pro as sorce
pre load.

what are the limitation of sorter transformation?

2 Answers   TCS,

---

Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y

2 Answers   Amazon,

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

Sequence generator, when you move from develoment to production how will you reset

0 Answers  

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

How to recover sessions in concurrent batches?

1 Answers  

---

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

---