When we are using Dynamic Cache,which options we will select
in session level?
- 1 Answers
- 4681 Views
- Cognizant, CTS, I also Faced
- E-Mail Answers
Answer / ankit
You need to select "Dynamic lookup cache" property in session and also select either "Inser else update" or "update else insert".
Thanks,
Ankit
| Is This Answer Correct ? | 1 Yes | 0 No |
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
What is sorter transformation?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
in which situations do u go for starflake schema ?
How can we handle two sessions in informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
what is the use of Data Mart?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
when will we go for unconnected lookup transformation in Informatica?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
Teradata 
