Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrence b/w joner and union transfermation
- 6 Answers
- 15550 Views
- I also Faced
- E-Mail Answers
Answer Posted / dillip
Joiner transformation is horizental transformation
but union is is vertical trans formation
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is difference between a gateway node and worker node?
How does a rank transform differ from aggregator transform functions max and min?
What is the meaning of decode in informatica?
Explain the shared cache and re-cache?
What is the difference between a repository server and a powerhouse?
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
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the uses of etl tools?
What is the sequence generator transformation in informatica?
What is an aggregator transformation?
Tell me about Propagate functions in informatica
How can we handle two sessions in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Informatica Checkpoints
without table how to come first record only in oracle?
