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
- 15105 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
How to create the source and target database connections in server manager?
wat are deployement groups in informatica, how it will be used for developers
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Define joiner transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the issues you have faced in your project? How did you overcome those issues?
What is deployment group?
What is informatica etl tool?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
can we override a native sql query within informatica? How do we do it?
State the limitations where we cannot use joiner in the mapping pipeline?
Explain how to import oracle sequence into informatica?
Design time, run time. If you don't create parameter what will happen
Differentiate between reusable transformation and mapplet.
What are the different versions of informatica?
