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
- 8679 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
can we override a native sql query within informatica? How do we do it?
What is the need of an ETL tool?
Quickly characterize reusable change?
Explain the informatica workflow?
How to implement security measures using repository manager?
What is an aggregator transformation?
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
hi real timers . iam waiting for ur reply regarding ETL TESTING
How do you take back up of repository?
What if the source is a flat-file?
As union transformation gives UNION ALL output, how you will get the UNION output?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is an expression transformation in informatica?
What is pmcmd command?
What is the command used to run a batch?
