Interested to Buy Any Domain ? << Click Here >> for more details...
When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
- 3 Answers
- 12885 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinod saini
Dynamic cache uses for updation of Master Table & SCD type 1
Static uses for Flatfile
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / veera
When/Under what circumstances do we use dynamic and static
cache in connected
lookup?
When/Under what circumstances do we use static cache in
unconnected lookup?
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / bc
we can use dynamic and static cache in connected
lookup..and we can use only static cache in unconnected
lookup.
| Is This Answer Correct ? | 0 Yes | 4 No |
State the limitations where we cannot use joiner in the mapping pipeline?
On which transformations you created partitions in your project?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
what is polling?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
What is mapping debugger?
what is index?how it can work in informatica
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
What is a command that used to run a batch?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
Teradata 
