Interested to Buy Any Domain ? << Click Here >> for more details...
if i have a file having record sal=10000,and when use router
with two groups having condition sal>5000 in one
group,sal>7000 in other group.and if two groups connected to
two targets.in which target sal=10000 will go?
- 9 Answers
- 17337 Views
- BirlaSoft, Genpact, L&T, Syntel, I also Faced
- E-Mail Answers
Answer Posted / nanda
The Record will go to default group
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
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 to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Define joiner transformation?
How to generate sequence numbers?
In which transformation you cannot drag ports into it?
What is rank index in rank transformation?
Define filter transformation?
How union transformation is used?
How an expression transformation differs from aggregator transformation?
How can we delete duplicate rows from flat files?
What is Session and Batches?
What is a mapplet/worklet in informatica?
How to partition the Session?
How to do unit testing in informatica?
Separate from a database, an information bazaar, and an information stockroom?
