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 |
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
Label in Informatica. How to remove existing Label.
How to view and Generate Metadata Reports?
What are the uses of a Parameter file?
what is the process we used in joiner transformation,there is no matching column in sources?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
performance tuning of Informatica
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
what is degenerated dimension
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
How are the sources and targets definitions imported in informatica designer?