What is the difference between SOURCE and TARGET BASED
COMMITS?
Answer Posted / buddy
source means reading from source and target means loading into
target
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the restrictions of union transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How we can use union transformation?
Explain lookup transformation is active in informatica
During the running session, output files are created by informatica server. Enlist few of them.
What is rank transform?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
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?
where to store informatica rejected data? How to extract the informatica rejected data?
EXL informatica Questions
What is union transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How are the sources and targets definitions imported in informatica designer?
What is meant by query override?