Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what are the limitations for bulk loading in informatica for
all kind of databases and transformations?

Question Posted / sujana

Answer Posted / sujana

v need to disable constraints while performing bulk loading

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

894

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

3949

Explain the types of transformations?

773

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1267

Where can we find the throughput option in informatica?

826

Difference between Data and Index Caches?

863

What is a difference between complete, stop and abort?

830

What is the difference between informatica 7.0 and 8.0?

735

Explain the scenario which compels informatica server to reject files?

901

Explain direct and indirect flat file loading (source file type) - informatica

1058

What is informatica? Why do we need it?

838

What are the guidelines to be followed while using union transformation?

860

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1706

What are the new features of informatica 9.x developer?

729

What are the types of schemas we have in data warehouse.

717