3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
Answer Posted / chiranjeevi k
We can use push down optimizationto to handle the huge
volume of data.
Thanks
Chiranjeevi
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is workflow monitor?
How to generate sequence numbers without using the sequence generator transformation?
How to generate sequence numbers using expression transformation?
Informatica Checkpoints
Explain the code page compatibility?
Explain sessions. Explain how batches are used to combine executions?
Explain informatica architecture - version 8 / 9
What is meant by active and passive transformation?
Differentiate between joiner and lookup transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the data movement modes in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.