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
- 11948 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 |
On which transformations you created partitions in your project?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
What is difference between a gateway node and worker node?
How to handle decimal places while importing a flatfile into informatica?
COM components can be used in Informatica
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What r the type of indexes u generally used in informatica?
What is CDC? How to implement CDC?
Can we combine a flatfile and a database table using an UNION transformation?
Why use shortcuts(Instead of making copies).
Teradata 
