we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.
Answers were Sorted based on User's Feedback
Answer / radha
We can use Router t/r also.
create as many conditions u want.
say, if rownum=2 then flow the data to target 1
if rownum=5 then flow to another target
go on....
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / ssrinivas624
any one heard about cume()function...
Using cume() funtction we can achieve this...
take any expresion after source qualifier add a row_cume
port and write an expression like cume(1)...
take a filter t/r write row_cume = 2 OR row_cume = 5 in
condition tab. Like any number of different rows u can
get...
two targets...
--->FILTER--->TARGET1
SQ--->EXP
--->FILTER--->TARGET2
same target...
SQ--->EXP--->FILTER--->TARGET
in the place of two filters u can go for router also...
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / lvpr
Another way is to use rank t/r and load data to target by
filtering 2 and 5 rows.
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / lvpr
Use two pipe lines...first pipeline add sequence gen t/r
and send data to dummy target...
In second pipeline take first pipe line's target as source
as we have seq numbers for each row now route 2 and 5 row
to diff target's or to same target
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / lokesh
src->sq->seq_gen->exp->flt->targer
in seq_gen property's put cycle 3,
write a condition as a nextlevel=2, insert into target.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raja
by using router it solve it.it is the best method to insert the data in to each target.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pavan
using Router transformation we can solve this.
create as many conditions u want.
Suppose,if rownum=2 then flow the data to target 1
if rownum=5 then flow to another target
go on....
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sateesh
Source-->SQ-->SequenceGenerator-->Exp-->Rtr-->Target
In Exp Transformation assign a variable port like v_num=10;
In Rtr Transformation use defined group give a condition
like
IIF(curvar>1,IIF(Mod(v_num,curvar)=0,0,1),1)
Please correct me if am wrong.
Is This Answer Correct ? | 1 Yes | 2 No |
one source to target loading insert new rows and update existing rows?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
What are the different types of transformation available in informatica.
how to move the mappings from your local machine to claint place?
Without source how to insert record to target?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
What are the parts of Informatica Server?
scenario
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
can we create index and drop index in exsisting table while using infomatica
In informatics server which files are created during the session rums?