Answer Posted / ahalya inturi
constraint based load order defines the order in which data
loads into the multiple targets based on primary key and
foreign key relationship.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How do you promote a non-reusable transformation to reusable transformation?
Differentiate between a database and data warehouse?
what are 3 tech challenges/ common issues you face?
What do you understand by SOA of Informatica?
What is the fact table?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is a joiner transformation and why it is an active one?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How can we use batches?
What is the sequence generator transformation in informatica?
How can we use mapping variables in informatica?
What is a snowflake schema?
my source is junk data how will u remove that junk data by using unix please any one replay me