What are the basic needs to join two sources in a source
qualifier?
Answers were Sorted based on User's Feedback
Answer / ricky
Both the sources should come from homogenious / same
database.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / swetha
Two sources should have primary and Foreign key relation ships.
Two sources should have matching data types.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / bidhar
Sources should be Homogeneous.Though they might not have a
joining condition.
For Example If you have Employee table and Dept Table and
the joining condition is on deptid then its not mandatory
that you must specify the joining condition.If you dont
specify the joining condition then it will have a cartesian
join.
Also the Ports Serial should be same as the SQ override
select.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
How can you validate all mappings in the repository simultaneously?
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
What is transformation?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
How can u work with remote database in informatica?did you work directly by using remote connections?
What are limitations of joiner transformation?
What do you mean incremental aggregation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
In which circumstances that informatica server creates Reject files?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out