Answer Posted / krishraj
It is simple logic, UNION fectches the commmon records
between two tables and it emliminated un-common records. So
it will be Active transformation which means it will change
the number of records.
Any other answers please....
| Is This Answer Correct ? | 1 Yes | 38 No |
Post New Answer View All Answers
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
whats the logic to load the lower level of granularity of data to fact table.
Write the unconnected lookup syntax?
What is a stored procedure transformation?
How do we call shell scripts from informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
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 measure objects?
What is a repository manager?
What is informatica powercenter repository?
How can one identify whether mapping is correct or not without connecting session?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the difference between a connected look up and unconnected lookup?
On which transformations you created partitions in your project?
