Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 8 Answers
- 12230 Views
- I also Faced
- E-Mail Answers
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 |
how we load the data from source to staging area
Can you access a repository created in previous version of Informatica?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the types of data that passes between informatica server and stored procedure?
HOW TO GET THE LATEST DATA IN SCD ?
Slowly changing dimensions, types and where will you use them
what is the difference between copy object import objects using repositery manager which one is best
how we do performence tuning in informatica
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
Teradata 
