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
- 8563 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / abhinaw prakash
Answer
1.We can do incremental loading by clicking on the check box inside Aggrgator T/R.Use filter transformation before Aggrgator to filter out rows and pass only the changed records to the flow.
2.One of the reasons could be the time its taking to build caches.to answer this more details of the maping is required.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
what is INFORMATICA TESTING process
What is the need of building a data warehouse?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
What are partitions in informatica and which one is used for better performance?
can you use flat file for repository?why?
Howmany ways yoU can update a relational source defintion and what are they?
Is snow flake or star schema used? If star schema means why?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null 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
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
What are the conditions needed to improve the performance of informatica aggregator transformation?
Teradata 
