Answer Posted / usha
constraint based loading:-we need to enable the option in
session properties....
the main use of this optione is used to load the data if
the tables have PK and Fk relationship (or)which is used to
load the data if the tables having parent and chaild
realation .....
if we diidnt enable this option session will fail
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the various types of transformation?
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?
What are the new features of informatica 9.x in developer level?
Explain the scenario which compels informatica server to reject files?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is native users?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to do unit testing in informatica?
How is union transformation utilized?
What is Data Caches size?
How do you use reject loader.
explain abt ur project architecture?
Explain lookup transformation source types in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is the need of etl tools?