Answer Posted / madhu
The Transformation which Converts the source(relational or
flat) datatype to Informatica datatype.
So it works as an intemediator between and source and
informatica server.
Tasks performed by qualifier transformation:-
1. Join data originating from the same source database.
2. Filter records when the Informatica Server reads source
data.
3. Specify an outer join rather than the default inner join.
4. Specify sorted ports.
5. Select only distinct values from the source.
6. Create a custom query to issue a special SELECT
statement for the Informatica Server to read source data.
| Is This Answer Correct ? | 34 Yes | 9 No |
Post New Answer View All Answers
Explain the types of lookup transformation?
What is decode in static cache?
Enlist the tasks for which source qualifier transformation is used.
How to load the data from people soft hrm to people soft erm using informatica?
What are active transformations.
How many ways are there to create ports?
Define mapplet?
Enlist the advantages of informatica.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
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?
What is the maplet?
where to store informatica rejected data?
What is a filter transformation and why it is an active one?
What is lookup change?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
