Why do flat file load is faster if you compare that with
table load ?
Please answer me.

Advance Thanks,
Manojkumar

Answer Posted / rayudu

One more thing is while loading the data into table
,informatica writes the data into database logs before
loading into target ,and this cant be done while loading a
flat file.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we store previous session logs?

658


What is aggregate cache in aggregator transformation?

712


Could you explain what is enterprise data warehouse?

646


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

726


What is a standalone command task?

773






Quickly characterize reusable change?

803


Can anyone tell me the new features in Informatica 9 Version?

1620


Under which circumstances, informatica server creates reject files?

683


What are the different types of transformation available in informatica.

725


What is the cumulative sum and moving sum?

865


How to generate or load values in to the target table based on a column value using informatica etl tool.

704


How to handle decimal places while importing a flatfile into informatica?

809


How would you join a node to the already existing domain?

793


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1706


explain one complex mapping with logic? sales project?

6288