Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic needs to join two sources in a source
qualifier?
- 4 Answers
- 12910 Views
- I also Faced
- E-Mail Answers
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 ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is unit testing?tell me proceedure
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Differentiate between source qualifier and filter transformation?
Explain about cumulative Sum or moving sum?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What does command task mean?
What is a sorter transformation?
how to load dimension table and fact table. plz tell me the steps.
Why is sorter an active transformation?
What are the types of data warehouses?
What the difference is between a database, a data warehouse and a data mart?
Design time, run time. If you don't create parameter what will happen
What is InformaticaPowerCenter?
Differentiate between router and filter transformation?
Global and Local shortcuts. Advantages.
