Hi Sarvan, Partialy u r rite but no need to go for target ,It will bydef

If I have router with 10 records, if the condition doesn’t
satisfy the records will pass to the default group,then
where can we see that records and where that records will store?

Question Posted / abhishek

4 Answers
9703 Views
I also Faced
E-Mail Answers

Answer Posted / abhishek

Hi Sarvan,
Partialy u r rite but no need to go for target ,It will
bydefault go for default group in router so u can see from
there
this is the main diff between router and joiner

Regards
Abhishek

Is This Answer Correct ?

1 Yes

12 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can we use mapping variables in informatica?

1001

What are the different ways to implement parallel processing in informatica?

1340

What is the difference between source qualifier transformations source filter to filter transformation?

996

What is target load order?

1186

What is decode in informatica?

1071

How can you define user defied event?

975

What is a pre-defined event and user-defined event?

972

Why do we need informatica?

925

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

8937

Briefly define a session task?

1053

difference between repository database and repository service?

1081

How will the document be delivered to me?

1018

Explain joiner transformation in informatica

1073

How many ways are there to create ports?

1234

What is confirmed fact in dataware housing?

6801