i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.
Answers were Sorted based on User's Feedback
Answer / vinay
Here are the steps that you will need to follow to catch record numbers 1,5,11,15,21,25,31,35.....so on.
Step1: Create an expression T/F and define a variable to count the number of records, say we name it as "CNT"
CNT (int) = CNT+1
Step2: In the same T/F, at the end of all the ports define a flag, say we name it as
flg_VALID_ROW (string(1))=
IIF((SUBSTR(TO_CHAR(CNT),-1)= '1' or
(SUBSTR(TO_CHAR(CNT),-1)= '5'),'Y','N')
Step3: Next define a Filter T/F, where you can catch hold of the record using flag = 'Y'
Filter Cond'n: flg_VALID_ROW = 'Y'
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sujana
satya rank transf is used 2 get max values..plz dont
misguide people
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rajasekhar
Better to take Sequence generator t/r. initial value 0 and
current value is 1 and increment by 4 . It is suitable for
ur query
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / abhishek upadhyay
It can be done easily by a SQ generator....The SQ generator
will assign the number as a PK to all the rows.
1
2
3
4
5.... and so on
Now when this is done you can write in the post target sql
that -
delete from target table where number <>1 or number <> 5
and then the target table will be left with only 1 and 5
records
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / bala
using sequence generator we can achieve desired result
enable SG properties as
start value=1
end value=5
enable cycle....
then in expression write a condition that
if SG values(num) are 1 and 5 then pass them into filter
iif(num=1 and num=5,true,false)
in filter ...make this column condition as true...
u will get every 1st and 5th record from your source
Is This Answer Correct ? | 1 Yes | 0 No |
1. Method
We can do it through
sq->Exp Trns->filter-->Target
!
SG
In filter trans by giving a condition "NUM=1
or NUM=5" we can get the result.
* But if you run the wf next time u need to change the NUM
value bcoz sq increments the value accrdng to the defined
condition whenever it runs the session.
2. Method
We can do it through Router trns
SQ—-Exp—Router--Target1 & Target2
!
SG
In Ist group NUM=1 & in 2nd group NUM=5.
where we'll define two groups, One for row 1 and other for
row 5.
* we need to chng the SG value every time
3. method
We can do it through parameters & variables
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / koti
take sequence generator to target and take expr
transformation to source qualifiew transf. and one new
port. and define that port as iif(sno=1 or 5,'true','false')
connect these to target.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / satya
after the SQ have EXPR t/r and add sequence to have unique
no's. add rank t/r get the ranks and have two filters one
for no=1 and other is for no=5 write them to the same target
hope this will address your scenario.
For more info reach me at satya.ylv@gmail.com
Is This Answer Correct ? | 4 Yes | 7 No |
Answer / vivek ranjan
I Think that you run the queary
select * from tablename where unique_no = 0 and unique_no =
5.
Definitally you featch 1 and 5 record every time when you
execute queary.
Is This Answer Correct ? | 1 Yes | 11 No |
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
how tokens will generate?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
What are the different transaction levels available in transaction control transformation?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
What are the associated ports in look up T/R.
what is galaxy repository?
What is olap (on-line analytical processing?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?