Interested to Buy Any Domain ? << Click Here >> for more details...
how can we check whether a particular cache is static or
dynamic?
- 1 Answers
- 8224 Views
- InfoCepts, TCS, I also Faced
- E-Mail Answers
Answer / praveen n
Double click the lookup transformation, check the properties
tab, if check port of dynamic lookup cache selected or not,
if it is selected it is dynamic cache and if not it is static
Static cache: it is read only and persistent
Dynamic cache: it is changing during the session runs.
Thanks
Praveen
| Is This Answer Correct ? | 20 Yes | 0 No |
What is informatica? What exactly are the practical uses in real world
What are the differences between oltp and olap?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
What is the sql query overwrite in source qualifier in informatica
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
How do you remove duplicate records in informatica? And how many ways are there to do it?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
How will you check the bottle necks in informatica? From where do you start checking?
How does a sorter cache works?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
Teradata 
