which transformation uses cache?
Answers were Sorted based on User's Feedback
Answer / minisweet85
lookup t/r
aggregater t/r
Rank t/r
Sorter t/r
seq gen t/r
Jioner t/r
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / rahul
JOINER T/R
SORTER T/R
AGGREAGATOR T/R
RANK T/R
LOOKUP T/R
| Is This Answer Correct ? | 4 Yes | 0 No |
can we use cartesian join in informatica
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
what r the transformations that r not involved in mapplet?
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?
Different types of Power center errors?
What is polling?
what is metadata?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
what is data modelling? what are types of modelling?In which suituation will use each one?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
what is mean by throghput? in informatica