Interested to Buy Any Domain ? << Click Here >> for more details...
Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
- 5 Answers
- 11346 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 |
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Enlist some properties of sessions.
I want load the data into target with out 1st and last record.
what is the size of u r project? and what is the size of source file?
how can we run workflow with pmcmd?
How do you load only null records into target?
what is correlated query?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
How can you validate all mappings in the repository simultaneously?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
explain about informatica server architecture?
when informatica 8 series released ?
Teradata 
