What are the diffrences between joiner transformation and
source qualifier transformation?
Answers were Sorted based on User's Feedback
Answer / swetha
yoU can join hetrogenious data sources in joiner
transformation which we can not achieve in source qualifier
transformation. yoU need matching keys to join two
relational sources in source qualifier transformation. Where
as you doesn't need matching keys to join two sources. Two
relational sources should come from same datasource in
source qualifier. yoU can join relatinal sources which aer
coming from different sources also.
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / 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 |
How to identify this row for insert and this row for update in dynamic lookup cache
what is the size of u r project? and what is the size of source file?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
How to create the source and target database connections in server manager?
Define enterprise data warehousing?
How can i set break points in debugging mode ? can explain steps please?
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
What is the command used to run a batch?
What is olap (on-line analytical processing?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
How can you define user defied event?
How would you join a node to the already existing domain?