Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amedela chandra sekhar
Union it support only same metadata in both the tables.
it will execute same metadata.
it means reject the unmatched data.
so reject some records.
so it changes the no of records
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
Informatica Checkpoints
What is meant by pre and post session shell command?
What are the issues you have faced in your project? How did you overcome those issues?
Explain what transformation and how many are there in informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the need of etl tools?
Target increases every day even though no new record was inserted
What is the commit type if you have a transaction control transformation in the mapping?
What do you mean by worklet?
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
can we override a native sql query within informatica? Where do we do it?
How to update source definition?
How to use procedural logic inside infromatica?
what is song in infrmatica...?
How does a rank transform differ from aggregator transform functions max and min?
