My source has 100 records. I have targets say in number 5.
all target tables has parent and child relationships in
between themselves. Now I want to load all 100 records into
all targets. How U can ensure that record inserted in parent
and then loaded into child.
Answer Posted / naveen
Use the target load plan & constriant based loading order in
session level and set the dependency
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is an expression transformation in informatica?
How can we remove the duplicates from flat file source?
What are the new features of Power Center 5.0?
What is the use of source qualifier?
What is the Rank index port in Rank transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
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?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is informatica worklet?
can anyone explain me about retail domain project in informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Please let me know how to make Data masking in informatica..
What is the difference between stop and abort in informatica
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How many ways are there to do 'remove duplicate records in informatica'?