Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6471 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the function of union transformation?
can u give example for factless fact table
my source is junk data how will u remove that junk data by using unix please any one replay me
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is a snowflake schema?
How many number of sessions can one group in batches?
What is resilience time?
what is index?how it can work in informatica
What is enterprise data warehousing?
What are the differences between a connected lookup and unconnected lookup?
What are the new features of informatica 9.x at the developer level?
What are roles and groups and benefits of using them?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain Dataware house architecture .how data flow from intial to end?
What are the different clients of powercenter?
