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 |
What is an unconnected transformation?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
explain abt joiner t/r?
what are objects in data warehouse?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to convert flat file into xml file? How to tune joiner?
what is a transforamation?
what is difference between mapping and mapplet ?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
Explain pushdown optimization and types in informatica
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
what is upstream and downstream transformation?