if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
Answer Posted / srinu
unonnected lookup
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Explain about Informatica server process that how it works relates to mapping variables?
What do you mean by channel change?
design of staging area?
What do you mean by enterprise data warehousing?
Differences between version 7.x and 8.x.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is lookup transformation?
update strategy transformation in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is repository manager?
What are session parameters ? How do you set them?
What are the new features of informatica 9.x at the developer level?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is a mapplet/worklet in informatica?