Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8510 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
What is parallel processing in informatica?
How to update or delete the rows in a target, which do not have key fields?
During the running session, output files are created by informatica server. Enlist few of them.
What is the difference between writing a joiner query in ANSI style and THETA style?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How many numbers of sessions can one group in batches?
Enlist the various types of transformations.
What is the use of source qualifier?
What is an aggregator transformation?
What are connected or unconnected transformations?
What is a dimensional model?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to join three sources using joiner? Explain though mapping flow.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the surrogate key?
