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 |
What are conformed dimensions?
Three date formats are there . How to change these three into One format without using expression transformation ?
enterprise datawarehouse your project phase by phase explain?
How to load a relational source into file taget?
Enlist some properties of sessions.
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
how will you remove the duplicate records from flat file without using sorter?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
In a sequential batch can you run the session if previous session fails?