Interested to Buy Any Domain ? << Click Here >> for more details...
what is constraint based load order
- 2 Answers
- 7600 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
The above answer with add one point we can configure the
constraint based load order in the Session Config obj tab.
| Is This Answer Correct ? | 1 Yes | 0 No |
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
WHAT IS FACT TABLES?
What is a candidate key?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
In which circumstances that informatica server creates Reject files?
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
How do you create single lookup transformation using multiple tables?
how can you load data into target table without leading zeor's
How does a sorter cache works?
who is the best faculty for informatica in hyderabad ameerpet?
Which files are created during the session rums by informatics server?
Teradata 
