Interested to Buy Any Domain ? << Click Here >> for more details...
I have in my source Records like 100,101,102 etc. I have
router transformation which has groups like one group is
empno=100, second group is empno>99. Now i want to know my
source record 100 loads into which group?
- 5 Answers
- 8171 Views
- Span Systems, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santosh
The record will be loaded into both the groups.
| Is This Answer Correct ? | 32 Yes | 0 No |
Answer / rampriya
if your input satisfies the condition of all your input
groups, then it will go into all of your groups excluding
default group. thats the only reason why router
transformation is active transformation
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / abhishek kumar
my source record 100 loads into one group. because router
first check first group than after second conscecuently.
| Is This Answer Correct ? | 3 Yes | 11 No |
guys which is the best institute in banglore to learn informatica??
I have 1200 records how can u send it in aggregator with good performance issues?
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 we can use union transformation?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
can anyone explain me about sales project in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
plz plz plz send client names and project names in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is tracing level and what are the types of tracing level?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
Teradata 
