How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
Answer Posted / ik
its possible by using 2 different sessions and connecting them in a single workflow
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the commit type if you have a transaction control transformation in the mapping?
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 many ways are there to create ports?
How to load a Dimension ? and how to load a fact table?
What are the new features of informatica 9.x in developer level?
Why union transformation is an active transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How do we call shell scripts from informatica?
What is deployment group?
What is the difference between Active and Passive transformation?
What does command task mean?
What are the new features of informatica 9.x developer?
What is complex mapping?
Differentiate between sessions and batches?