What is the target load order?
Answers were Sorted based on User's Feedback
Answer / swetha
yoU specify the target load order based on source qualifiers
in a maping. If u have the multiple source qualifiers
connected to the multiple targets, yoU can designatethe
order in which informatica server loads data into the targets.
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / kareem
By using the target load order,We can order the target's
(i.e In which target ou like to load the data first)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rashmi garg
when we set the target load order, we create the groups,
each group may have multiple targets.
so data is loaded concurrently in all the targets of one
group and sequentially in different groups in the order.
| Is This Answer Correct ? | 0 Yes | 8 No |
how can u tune u r informatica mapppings
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
draw informatica architecture 8.6 ?
What is sq transformation?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
What is rank transform?
can you use flat file for repository?why?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Describe an informatica powercenter?
What is the filename which you need to configure in UNIX while installing infromatica?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?