What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 30523 Views
- I also Faced
- E-Mail Answers
Answer Posted / yaseen
we can create multiple input groups,but only one
out put group
Union Transformation combines data record vertically from multiple sources, having same metadata.
The structure and Data types should be same while using Union transformation
Join Transformation combines data record horizontally based on
join condition.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is an Integration service in Informatica?
Explain what are the different versions of informatica?
What does reusable transformation mean?
what is INFORMATICA TESTING process
How to partition the Session?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How you can differentiate between connected lookup and unconnected lookup?
What is the benefit of partitioning a session?
What are the new features of informatica 9.x in developer level?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What are the transformations that are not supported in mapplet?
How do you take back up of repository?
Explain the pipeline partition with real time example?
When do you use sql override in a lookup transformation?
