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 is sql override?what is the use of it?

4 Answers   Sonata,

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---

What is confirmed dimension and fact?

7 Answers  

---

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

---

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

---

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

What is synonym?

2 Answers   Patni,

---

What does role playing dimension mean?

0 Answers  

---