Interested to Buy Any Domain ? << Click Here >> for more details...
What are the diffrences between joiner transformation and
source qualifier transformation?
- 2 Answers
- 17176 Views
- I also Faced
- E-Mail Answers
Answer Posted / david
One important thing is
IN source Qualifier 1)the columns used in the condition must
have primary-key and foreign-key relationship(Compulsory)
For example
If the condition is
Emp.deptno = dept.deptno1
The depeno and deptno1 should have primary and foreign
key relation
2)The datatypes of the couumns must be same
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How do you handle two sessions in Informatica
What is the difference between STOP and ABORT options in Workflow Monitor?
What is data caches/ index caches?
What is the meaning of decode in informatica?
What are active transformations.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
r u done any partitions in ur project?
How to open an older version of an object in the workspace?
Enterprise data warehouse your projects phase by phase explain?
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 reusable transformation?
What is the difference between stop and abort in informatica
How to extract sap data using informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How can we use mapping variables in informatica? Where do we use them?
