Interested to Buy Any Domain ? << Click Here >> for more details...
There are 3 groups in router transformation in which there
are no conditions mentioned, so what happens if I connect
these groups to the 3 targets? How many records gets into
each target.(suppose if we are getting 10 records from the
source)
- 4 Answers
- 8897 Views
- I also Faced
- E-Mail Answers
Answer Posted / raju
Without condtion by default all rows are load to given target/targets.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Global and Local shortcuts. Advantages.
How will the document be delivered to me?
What is the meaning of decode in informatica?
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 is the surrogate key?
Enlist the advantages of informatica.
What is informatica?
Can anyone tell me the new features in Informatica 9 Version?
Explain dynamic target flat file name generation in informatica
Why union transformation is an active transformation?
tell me the rules and responsblites in our project(my project is development)
Explain about cumulative Sum or moving sum?
Explain the aggregator transformation?
Explain the difference between a data warehouse and a data mart?
What is the format of informatica objects in a repository?
