in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answers were Sorted based on User's Feedback
Answer / pavana
You can use sequence generator and then in exp trn, use a
variable which reads the 1st number the seq generates and
use filter transformation and take only 1st generated row
and +10th record.
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / jaybrata
have you guys heard of Informatica CUME() function?
Don't use seq generator, aggregator, sq override nothing.
Simply in a expression, calculate,
v_cume = CUME(1)
and after that in a filter use,
v_cume=1 OR v_cume=10
- Jaybrata
(Check www.dwbiconcepts.com)
Is This Answer Correct ? | 14 Yes | 3 No |
Answer / prakash kumar kumhar
ower write sq ("select *from <tableNmae> where rownum <= 10;")
than use two aggregation transformation (in first use first(),and in second use last() for each column)from sq to target.
note: use two target table in which u want to load that two records.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sathish
source may be flat file or database just you use sequence ganarater then filter copy the nextval port to filter write condition nextval=1 or nextval=10 you get only 1 and 10 th records
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prasuna
Ya ..that is right in case its a table..in case of flat
file..i think we cannot use Over ride ...i think using
sequence generator or by finding rownum in Expression
transformation ..after that by filtering two rows ..we get
the output..
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / chandrasekhar
You need to use MOD function based on you can filter it
out.. then you will get 1..10..20..30....like we will get it
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / eswar
As Prakash said
ower write sq ("select *from <tableNmae> where rownum <=
10;")
Instead of using Aggregator its better if we use Router
Transformation, wherefrom we can route the rows to target
(s).
note: use two target table in which u want to load that two
records
====
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / prasuna
sorry,i need here..for example if i have 50 Records..in that
i need 1st and 10th..
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / sujana
i think v shud use FIRST and LAST functions in aggregator..
Is This Answer Correct ? | 0 Yes | 8 No |
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
What is a transaction control transformation?
difference between source based commit? and target based commit? which is better with respect to performance?
What are the different types of Type2 dimension maping?
what is dynamic cashe
Explain pmcmd command usage in informatica
when will we go for unconnected lookup transformation in Informatica?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
What is olap (on-line analytical processing?
What is InformaticaPowerCenter?
Explain what are the different versions of informatica?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.