Hello Everyone,i have one question on sequence generator.i
have two targets and the records comes from the source will
place in the targets like 1-10 rec in target1 and 11-20 rec
in target2,21-30 rec in target1...etc so any one can help
me? plz..Thanq in adv.
- 7 Answers
- 12631 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ahalyabest@gmail.com
SQ---> SEQ GEN---> EXP--> ROUTER---> TRG1, TRG2, TRG3, TRG4
in seq generator properties
start value-1
increment value-1
end value-4
current value-1
cycle-true
reset-true
in router conditions
4 conditions
group 1= iif ((nextval=1)1,0)
group 2=iif (( nextval=2)1,0)
group 3=iif((nextval=3)1,0)
group 4=iif((nextval=4)1,0)
connect
group1-->target1
group2-->target2
group3-->target3
group4-->target4
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the types of data warehouses?
What is the meaning of decode in informatica?
What is target designer and target load order?
Why update strategy and union transformations are active?
lookup transformation with screenshots
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How can we store previous session logs?
Explain direct and indirect flat file loading (source file type) - 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 are data-driven sessions?
Explain in detail scd type 2 through mapping.
What are the types of lookup transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is the procedure for creating independent data marts from informatica 7.1?
Difference between Data and Index Caches?
