explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
Answer Posted / rekha
NORMAL LOAD : IT LOADS THE RECORD ONE BY ONE AND WRITES LOG
FOR EACH FILE . IT TAKES MORE TIME TO COMPLETE
BULK LOAD : I LOAD THE NUMBER OF RECORDS AT A TIME ,IT WONT
FALLOW ANT LOG FILES OR TRACE LEVELS . IT TAKES LESS TIME
USE THE BULK MODE FOR IMPROVING THE SESSION PERFORMANCE
| Is This Answer Correct ? | 49 Yes | 4 No |
Post New Answer View All Answers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain what transformation and how many are there in informatica?
Can we create a Integration service without a Repository service and vice versa?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What are the prerequisite tasks to achieve the session partition?
Mention some types of transformation?
How you can differentiate between connected lookup and unconnected lookup?
Explain lookup transformation source types in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a router transformation?
How can we use mapping variables in informatica?
What are data-driven sessions?
What is the status code in stored procedure transformation?