Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How we can create indexes after completing the load process?
What does “tail –f” command do and what is its use as an Informatica admin.
Differentiate between a repository server and a powerhouse?
Explain lookup transformation is active in informatica
Explain load alternative records / rows into multiple targets - informatica
where to store informatica rejected data? How to extract the informatica rejected data?
What are the settings that you use to configure the joiner transformation?
What is DR strategy for Informatica project?
Differentiate between reusable transformation and mapplet.
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 lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How can we delete duplicate rows from flat files?
How to partition the Session?
What is a filter transformation and why it is an active one?
