Hi,
In Router transformation I created two groups .
One is Passthrough=> True
Second one is CorrectId’s => Invest>50000
Here I have one doubt. Can’t I treat default group as
Passthrough group (fist group) . Is there any difference
between default group and Passthrough group in this
scenario?
Let me know if you want more information about this
scenario.
Advance thanks.
- 3 Answers
- 8829 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / c manojkumar
Thanks Srinivas and priyank for your inputs.
Yes I got it now. I can't use default group insted of
passthrough. since passthrough group will have all the
records where as defalult group will have only few i.e. the
records which did not meet any of the group conditions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the new features of Power Center 5.0?
What do you mean by blocking transformation?
explan ur project architecture?
What is the function of look up transformation?
What are the different ways to implement parallel processing in informatica?
What is lookup transformation?
how many types of dimensions are available in informatica?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What are session parameters ? How do you set them?
What are the new features of informatica 9.x at the developer level?
generate date / time dimension in informatica
Name the different lookup cache(s)?
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 can informatica be used for an organization?
