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'

Answer / sujana

satya rank transf is used 2 get max values..plz dont
misguide people

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

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

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

Answer / sanjay

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

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.

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

Answer / sunny

Simple.Take arithematic calculation, record divisible by five if result is zero then pass it where u want,for first record pass it directly.It's c logic man.i gave one idea that much only.

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.

how many types of dimensions are available in informatica?

0 Answers  

What is sql query override? When did u use sql query override?

1 Answers   TCS,

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

In any project how many mappings they will use(minimum)?

1 Answers  

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  

how we can update a target table without update strategy and update override?

3 Answers   TCS,

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

Can you start a session inside a batch individually?

2 Answers  

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,