Hi
I have been asked several times the following questions.
1.How does one do incremnental loading
2.Scenario - You are trying to load reasonable amount of
rows into the target table, and its taking a helluva lot of
time.What could be the reasons?
I hate to answer these tw0 , gives me nightmares to even
think of it!!!
3.Tell me any complex situation you have faced( as an
Informatica Developer) and how did you resolve it.
4.tell me any complex mapping that you have done.
All the experienced people out there , please please, reply
to these questions.
- 2 Answers
- 7804 Views
- I also Faced
- E-Mail Answers
Answer Posted / chiky
How does one do incremnental loading
CHECK OUT THE OPTION, truncate target table option in
sesson==> target properties.
this makes the incremental load.
Scenario - You are trying to load reasonable amount of
rows into the target table, and its taking a helluva lot of
time.What could be the reasons?
use bulk loading in session properties.
use less record as master table in joiner
use filter in first of the mappings
dont use unwanted columns in source qualifier.. better use
SQL overriding.
use dynamic lookup only if in use.
tune your query what ever reads from db.
use partitioning of table if records are huge in number.
3.Tell me any complex situation you have faced( as an
Informatica Developer) and how did you resolve it.
4.tell me any complex mapping that you have done.
AM not enough experienced to answer this two questions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
How might you approve all mappings in the archive all the while?
What is the need of an ETL tool?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is data caches/ index caches?
What is the difference between informatica 7.0 and 8.0?
What is an unconnected transformation?
Explain what are the different versions of informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the function of union transformation?
Where can we find the throughput option in informatica?
How union transformation is used?
Explain the difference between mapping parameter and mapping variable?
write a query to retrieve the latest records from the table sorted by version(scd)
