If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?
- 2 Answers
- 5751 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hari
create mapping like
source -- sorter -- expression -- filter -- target.
here sorter is used to send data by ascending order data
this is not mandatory.
Expression is need to create variable port which will count
the rows which are comming in.
Filter having condition like if count value >=51 and count
value <= 100.
| Is This Answer Correct ? | 6 Yes | 0 No |
Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target
src--->sq---> expression--->filter--->target
| Is This Answer Correct ? | 1 Yes | 0 No |
Why do we need informatica?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Mention few power centre client applications with their basic purpose?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Can you start a batches with in a batch?
What is option by which we can run all the sessions in a batch simultaneously?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
How do you convert single row from source into three rows into target?
I want load the data into target with out 1st and last record.
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
How to create a non-reusable instance of reusable transformations?
How does a sorter cache works?
Teradata 
