Interested to Buy Any Domain ? << Click Here >> for more details...
Hi please try to reply with answer. my mail id is
raghu.1028@gmail.com.
if the source is having millions of records, but having
theree target tables. As per user the first record need to
insert into first target and second record in to a second
target and third into third target, similarly the process
needs to repeat?
- 5 Answers
- 8446 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivas
sequence generator>expression trans>router>targets
in router create 2 userdefined groups, 1 default group.
ie total 3 o/p groups
group1 condtion . mod(nextval,3)=0
group2 condtion . mod(nextval,3)=1
group3 condtion . mod(nextval,3)=2
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / siddiq
First U will create sequence number for the 3records
using sequence generator t/r then U can create an
expression t/r in that use the mod function like
mod(seqno,3)=1
mod(seqno,3)=2
mod(seqno,3)=0
then u will get the resulr
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jitendra
We can clearly understand that we need a Router
transformation to route or filter source data to the three
target tables. Now the question is what will be the filter
conditions. First of all we need an Expression
Transformation where we have all the source table columns
and along with that we have another i/o port say seq_num,
which is gets sequence numbers for each source row from the
port NextVal of a Sequence Generator start value 0 and
increment by 1. Now the filter condition for the three
router groups will be:
MOD(SEQ_NUM,3)=1 connected to 1st target table,
MOD(SEQ_NUM,3)=2 connected to 2nd target table,
MOD(SEQ_NUM,3)=0 connected to 3rd target table.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / balaganesh
Using Sequence Generator and router we can achive this
problem.
In Seq Gen:
1) Set current value is 1 and end value is 3. Also, enable
the recycle option.
Now using router you can separate the records into target.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / mural
hi srinivas this is lenthy process it is not possible
| Is This Answer Correct ? | 0 Yes | 0 No |
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
What are snapshots?
What is staging area referring to?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what is HISTOGRAM? how to generate statistics?
how do u really know that paging to disk is happening while u are using a lookup transform?
what are the reports developed in sap bw project and what is the requirement for developing it?
How many types of transformations supported by sorted input?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
Teradata 
