I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?
- 5 Answers
- 10246 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / gyana
source--->sq--->attached a sequence generator with settings
current value=1
start value=1
end value=3
incrimented by=1
cycle=yes
------->router(3groups)--->3 targets
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a connected transformation?
What are the types of presistent cache in look up tr.
What does cheating measurement mean?
How you know when to use a static cache and dynamic cache in lookup transformation?
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 is the hint? how to use it to reduce the query processing in program?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the meaning of up gradation of repository?
What is a sequence generator transformation?
Explain the difference between a data warehouse and a data mart?
What are the different transaction levels available in transaction control transformation?
tell me about your project functionality
What are the main features of Oracle 8i with context to datawarehouse?
What is the cumulative sum and moving sum?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
