we have 20 records in source system, when we run for the 1st
time, it should load only 10 records into the target, when
you run for the second time it should load another 10 record
which are not loaded. How do we do that? Can we write a SQL
query in source qualifier to do it. This q' is asked in one
f the interviews. Please let me know if anyone knows. Thanks
Answers were Sorted based on User's Feedback
Answer / suresh
SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> num >= MVar1 and num <=MVar2
Mvar1 and MVar2 are assigned with the value of 1 and 10 respectively
in EXP=>V-port - setvariable(mvar1, 10)
V-port - setvariable(mvar1, 20)
after the execution of the mapping 10 and 20 values are stored in the mvar1 and mvar2 into the repository
Is This Answer Correct ? | 0 Yes | 0 No |
1. Create a mapping variable $$SESSION.
2. Link from SQ to Router t/r.
3. Create two group
a. SETMAXVARIABLE($$SESSION,$$SESSION+1) % 2 = 1
b. SETMAXVARIABLE($$SESSION,$$SESSION+1) % 2 = 0
4. Link both group to two filter and create two Sequence geneter and check the reset option.
5. Link the sequence generator to filter t/r.
6. Keep the condition as "NEXTVAL<=10" for first filter.
7. Keep the condition as "NEXTVAL>10" for second filter.
8. Link the two filter to two different target instance.
Let me know if any things wrong.
Thanks & Regards
Santosh Kumar Sarangi
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / babu
Hi,
If u r source is Relational,then u can write sqloverride.
i.e
SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> (num >= MVar1 and num <=MVar2)
NOTE: MVar1,MVar2 are mapping variables the initial values
of these variables 1,10 with respectivelly.
after completion of firsst run the variables are increased
11,20 respectivelly.all are knows how to declare the
mapping variables.
IF THERE IS ANY WRONG PLEASE CORRECT ME.
Thanks,
Babu
Is This Answer Correct ? | 2 Yes | 4 No |
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Mention a few design and development best practices for informatica?
State the differences between sql override and lookup override?
What are the diffrences between joiner transformation and source qualifier transformation?
Can you copy the session to a different folder or repository?
What is update strategy transform?
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is Performance tuning in Informatica?
What is domain and gateway node?
Mapplets can you use an active transformation in a mapplet,
how we can load rejected record's at run time?(not through bad files)