Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15320 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi,
Mappimg::
SRC=>SQ=>SEQ GEN=>EXP=>RTR=>TRG1 &TRG2
First we have to take 4 mapping variables,those are
VAR1=1 increment by 20
VAR2=10 increment by 20
VAR3=11 increment by 20
VAR4=20 increment by 20
in RTR two groups are there group 1::
IIF( NEXTVAL>=VAR1 AND NEXTVAL<=VAR2)
GROUP 2 :: IIF( NEXTVAL>=VAR3 AND NEXTVAL<=VAR4)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain in detail about scd type 1 through mapping.
How does the aggregator transformation handle null values?
What's the layout of parameter file (what does a parameter file contain?)?
Define sessions in informatica etl?
What you know about transaction control transformation?
What are the different options available for update strategy?
What are the different ways to implement parallel processing in informatica?
What is a joiner transformation and why it is an active one?
What are the static cache and dynamic cache in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Differentiate between a database and data warehouse?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are Dimensional table?
What is domain in terms of informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
