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
- 12357 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 to update source definition?
Filter transformation in the condition one of the data is NULL would the record be dropped.
Explain factlessfact table with scenario
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
What is the use of target designer?
How to display First letter of Names in Caps?
How do you change parameter when you move it from development to production.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is the function of union transformation?
How to load data in informatica ?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Teradata 
