Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 15793 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manu
Hi IBM,
I have a solution for this.
1) From source qualifier get the records to the Expression.
2) Use one Sequence generator in which set the max value as
3 , enable cycle option. Connect it to the expression.
3) then use router & create 2 groups, 1st group condition
as Next value = 1 another as next value = 2 and default.
4) These should be connected to the 3 target tables.
The requirement will be achieved.
| Is This Answer Correct ? | 29 Yes | 3 No |
Answer / srinivas
I had another simple solution ...
1.use router transforamation .. generate 3 groups and use
sequence generator ... next value connnct to router
transformation... and logic is
mod(next,3)=1,mod(next,3)=2,mod(next,3)=0,,
connct to 3 targets load it...
| Is This Answer Correct ? | 21 Yes | 4 No |
Answer / manu
Hi Srinivas,
Even I gave the same solution. Can you please check.
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / im
Using Constraint Based Loading option in SQ T/r......
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / jayesh
Use target load plan.
Option is available in mappping designer.
| Is This Answer Correct ? | 0 Yes | 5 No |
performance wise which one is better in joiner and lookup transformation
In real time scenario where can we use mapping parameters and variables?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
What are the components of the workflow manager?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
I have source like this 1:2;3. so i want to load the target as 123
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
Explain the shared cache and re-cache?
 Informatica Checkpoints
I want skip first 5 rows to load in to target? what will be the logic at session level ??
how we can load rejected record's at run time?(not through bad files)
what is parallel querying and what r hints.
Teradata 
