Interested to Buy Any Domain ? << Click Here >> for more details...
I have a scenario with router transformation. but i dont want
to capture records from default group. how can we achieve
this.
- 3 Answers
- 13691 Views
- Amdocs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kishor baindoor
Dont connect any out port of router's default group to next
stage.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / ankita jain
Just ignore the data from default group.. means dont connect to it. See below example for more details
http://www.tutorial.tecktricks.com/example-of-router-transformation-in-informatica-example-1/
| Is This Answer Correct ? | 1 Yes | 0 No |
Why filter transformation is an active one?
What is the difference between unicode & ascii mode data movement in informatica?
when we go for unconnected lookup transformation? and why?
How to update a particular record in target with out running whole workflow?
If I am having 6 flat files in data. How can you load the data at a time
Mention a few design and development best practices for 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 metadata reporter?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
How to join three sources using joiner?
can we override a native sql query within informatica? How do we do it?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
Teradata 
