Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
- 5 Answers
- 9868 Views
- Flextronics, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / joe
We cannot use a sorter because it will shuffle the data.
For the last 20 rows. In a seperate pipeline use aggregator
and do a Count(key) and Max(key) to get the total number of
rows.
use an output port o_count and o_max to populate this count
to an expression transformation before the Filter.
o_count_last_20 = o_count - 20
i.e. if there are 35 records we need records from 15 to 35
In the filter check nextval between o_count_last_20 and
o_Max
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sunny
Hello joe, your solution is partially correct - what if the
records are not in sequence to do MAX minus 20 ? I guess
this logic can be applied only after passing through
sequence generator, by getting a sequence number.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / joe
1. Use a sequence generator to associate a NEXTVAL to the
row.
2. Filter condition : NextVal <=20
For source- dbase: Do a filter at SQ by including the
following condition . WHERE Rownum <=20
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sri
For this you can write SQL query by TOP clause in expression
transformation.
Or else You can use Rank Transformation.
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / raju
You can also achieve using following flow in the mapping.
1)Create an out put port SNO in expression transformation
and connect it to NEXTVAL port in sequence generator
transformation.
2)Use sorter transformation.In sorter ,use SNO port as key
column and Direction is Descending.
3)Use filter transformation with filter condition as
SNO<=20.
| Is This Answer Correct ? | 0 Yes | 3 No |
wht is cdc?how to use it in creation of mappings?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
What do you mean by enterprise data warehousing?
How to do Integration testing in Informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
In joiner, how to load Master table in Target?
What are the data movement modes in informatcia?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Teradata 
